Top # query question

[Gregg]

I have a table with store#,upc#,startingDate etc. in it.
I need a query that will give me the top 5 startingDates
ordered DESC for each store#/upc# combination. Thank you
for your help.

 

[M.L. Sco Scofield]

Take a look at method 1 in the article at
http://support.microsoft.com/default.aspx?scid=kb;en-us;210039. (Although
the article is for Access 2000, it works just fine in 2002 and 2003.)

Good luck.

Sco

 

[Jeff Boyce]

Gregg

Just a note -- use of the "#" symbol in your fieldnames could confuse
Access. You may want to use square brackets ([]) around fieldnames
containing spaces or "#" or other special symbols.

 

[Guest]

Thank you

-----Original Message-----
Take a look at method 1 in the article at
http://support.microsoft.com/default.aspx?scid=kb;en- us;210039. (Although
the article is for Access 2000, it works just fine in 2002 and 2003.)

Good luck.

Sco




.