Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Group-by expressions exceeded' (Access 2000)

    I get the following message when running a query...

    ODBC -- call failed

    [Microsoft][ODBC SQL Server Driver]Maximum number of group by expressions exceeded (16 max, 17 found). (#253)

    The Access help comes up blank and the guy who controls the SQL server can't find any setting for grouping levels. Not sure whether the solution is within Access or the SQL server.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: 'Group-by expressions exceeded' (Access 2000)

    Hi,
    Sounds like Q155893 to me. Not sure how much help it will be though!
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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