[AccessD] Totals Query: Top Predicate

Yes.  The top 5 of each year/month combination.


Mark


On Mon, 7 Feb 2005 14:19:39 -0500, Susan Harkins
<ssharkins at bellsouth.net> wrote:
> 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
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>