[AccessD] Totals Query: Top Predicate

Heenan, Lambert Lambert.Heenan at AIG.com
Mon Feb 7 13:54:48 CST 2005


See

http://support.microsoft.com/kb/q153747/

for two methods.

Lambert

> -----Original Message-----
> From:	accessd-bounces at databaseadvisors.com
> [SMTP:accessd-bounces at databaseadvisors.com] On Behalf Of Admin Sparky
> Sent:	Monday, February 07, 2005 2:30 PM
> To:	Access Developers discussion and problem solving
> Subject:	Re: [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
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



More information about the AccessD mailing list