My Tables and fields are:
ProductName - can be Product 1 or Product 2.
Note: Customers may have purchased same product on different dates.
I am trying to come up with a Query that will output all customers including 2 Boolean fields, let's call them boolProduct1 and boolProduct2.
boolProduct1 will be True if the customer has purchased Product 1.
boolProduct2 will be True if the customer has purchased Product 2.
To help you test your queries, I have uploaded an Access database with sample data