Is Group By sequence important?

  • Thread starter Thread starter Razor
  • Start date Start date
R

Razor

Hi,

In a "Totals" (Group By) query, I want to group by 2
fields and apply group functions on some third field (sum
or count).

Does the order with which I group matter?

i.e. Is ...group by A,B...
equivalent to
Group by B,A...

in terms of the resultsets I obtain?

Can I be indifferent between these 2 queries?

Thanks,

Razor
 
The groups are divided as Cartesian product groups so I don't think the
order of the Fields in the GROUP BY clause makes any difference.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top