• ‘Group-by expressions exceeded’ (Access 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » ‘Group-by expressions exceeded’ (Access 2000)

    Author
    Topic
    #378154

    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.

    Viewing 0 reply threads
    Author
    Replies
    Viewing 0 reply threads
    Reply To: ‘Group-by expressions exceeded’ (Access 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: