[AccessD] Totals Query: Top Predicate

See:

http://support.microsoft.com/default.aspx?scid=kb;en-us;210039

Jim 


-----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