Susan Harkins
ssharkins at bellsouth.net
Mon Feb 7 13:19:39 CST 2005
You need the top 5 from each group, right? Susan H. Group, I have a totals query grouped by year, then month. I would like to return the top 5 records for each year/month combination. What are my options? At the moment, the top predicate merely returns the top 5 records for the first year/month combination. Mark Mitsules -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com