My Tables and fields are:
- I have 4 products, each with a bunch of variants, e.g.
Note: Customers may have purchased same product on different dates
I am trying to come up with a Crosstab Query to create a recordset with a row for each Customer and a column with a count of Purchases for each Product (aggregating the variants of each Product).
CustomerID, Product1, Product2, Product3, Product4
1234 4 0 1 0