[AccessD] Getting the Top 3 Records of every n

Hi Francisco

Did you ever get a solution to this?
If not, look the archive:

http://databaseadvisors.com/mailman/htdig/accessd/2003-May/006636.html 

/gustav

>>> fhtapia at gmail.com 17-04-2007 21:18 >>>
I know how to do this in Sql Server, but have been thinking it over on how
to do this via the QBE grid in Access...


The situation is there is a list like so

Bob  100
Bob  090
Bob  050
Bob  010
Bill   250
Bill   100
Bill   070
Bill   050
Jim   etc...


What is required, is that they want to be able to obtain the top 3 records
for each customer ie, Top 3 records sorted in descending order by the qty.

Thanks guys

-- 
-Francisco
http://sqlthis.blogspot.com | Tsql and More...