I have a table with the following columns: Vendor, Product.
I need to create a query that will count for each Vendor/Product combination so that I get the following:
Vendor | Product | Count
ACME ABC 1
ACME ABC 2
ACME DEF 1
BOLTS GHI 1
This the reason behind this, I need to be able to use the count field in another query so I need that count to be dynamic based on the info currently in that table.
I can do this in a report, but have tried and tried, searched and searched and can't find a solution to work in a query.
Any help would be appreciated.