Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    67

    Unanswered: Here is the error

    I have report base on subquery and I'm trying to subtotal in the report but I'm getting error, (Multi-level GROUP BY clause is not allowed in a subquery. (Error 3612)
    An SQL subquery cannot list more than one field in a GROUP BY clause.)

    please help.

  2. #2
    Join Date
    Sep 2002
    Location
    South Wales
    Posts
    580
    Post the SQL please - You are not likely to receive a response otherwise.
    Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •