Below is from the help file. If I understand this change I can nolonger just list the fields I want grouped. I have to list the field grouping of all the fields.
So if I have table with 5 fields I must list all 5 as in
"Group by 3,2,1,4,5" even if all I'm concern with is with fields 3 and 2. Can anybody confirm? TIA
John
The GROUP BY clause does not support Memo or General fields.
The GROUP BY clause must list every field in the SELECT list, except for fields contained in an aggregate function, such as the COUNT( ) function. In addition, the GROUP BY clause must also list every field in a HAVING clause, except for fields contained in an aggregate function
John Fabiani
Woodland, CA