[AccessD] Totals Query: Top Predicate

SELECT Distinct Month year, loop through each of these, selecting top 5.
Insert each of these selects into a temp table then select from the temp
table. This would be much easier as a stored procedure in SQL :)

D

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Admin Sparky
Sent: Monday, February 07, 2005 10:47 AM
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