>Don't you need to precede the group by with the order by? Otherwise the un-ordered results will be inaccurate.

It's not a requirement to use ORDER BY with GROUP BY. ORDER BY will just sort the resultant set. I'm not sure about VFP's implementation but SQL Server does an implicit sort to solve a query with a GROUP BY.

-Mike