Mike & Doris Manning
mikedorism at adelphia.net
Mon Feb 7 12:54:36 CST 2005
Sort the total value in descending order and take top 5. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Admin Sparky Sent: Monday, February 07, 2005 1:47 PM To: accessd at databaseadvisors.com Subject: [AccessD] Totals Query: Top Predicate 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