Max number of fields in query

  • Thread starter Thread starter wwaiter
  • Start date Start date
W

wwaiter

I have a many fields in my query. When I run this query,
how I get the following error message: "To many group by
clause in this query." I have 137 fields all together.



Ifs ther a maximum number of fields I can have in a query?
 
wwaiter said:
I have a many fields in my query. When I run this query,
how I get the following error message: "To many group by
clause in this query." I have 137 fields all together.



Ifs ther a maximum number of fields I can have in a query?
Click to expand...

Turn off the View Totals. The limit on how many fields can be "Grouped By" is lower
than how many you can have in a normal Select query.
 
Back
Top