In MS Access 2003, how do I code a query for a COUNT, grouping through two criteria? I need to query a set of records to find out how often each client bought from each seller.
e.g.: I need to ask how many times did each client purchase from each seller. Any ideas?
The result needs to have CLIENTID, Number of Purchases, SellerID.