Count Records in a recordset

[elgoober]

Hi

I have a table that contains 1 year of sales.

Fields include Item,NetSale,Customer,Month.

I need to count how many times an item has been bought by a customer.

I can see from a report wizard how the count is achieved - but I need to action this at query level.

Any thoughts/help greatly appreciated.

Cheers

Paul

 

[namliam]

Just make a group by/totals query...
It will end up looking (in sql) something like:
select customer, item, count(*)
from yorutable
group by cucstomer, item

Good luck!

 

[elgoober]

Cheers Namliam

Have a good day

Paul