I have a request for our top 10 clients for the month of March/05 (the top 10 being the ten who place the most amount of orders with us). This I was able to do, but then for each of those 10 clients I am asked for there top 10 orders. This is what I cannot get my query to give me. What I need to know is that client x (who would be one of the top 10) top 10 orders were
200 product a
100 product b
600 product s
etc up to 10 products
Can I accomplish this on the query grid or do I need to use SQL ? If I do use SQL is this a case where I would have to join a query/table to itself?
Iam using MS Access 2000
Thanks
Liz
200 product a
100 product b
600 product s
etc up to 10 products
Can I accomplish this on the query grid or do I need to use SQL ? If I do use SQL is this a case where I would have to join a query/table to itself?
Iam using MS Access 2000
Thanks
Liz
