Creating a Count for while applying multiple criteria..Help Plz!

[metube]

Hi,



I really need a big favour! LOL

I have a database which contains sales from stores (each customer has their own account), but transactions are only entered per product.

I am looking for a way to find out which customers have bought a set of products.

The the feilds are as such:
Date
Customer
Product
Quantity
Total Cost

There are relationship links for more indepth data about customers and the Products.

I dont want to have to export to excel and start running if statments I'd rather run them from within the database, but I have no idea.

I thought this would be easy but Im lost

Hopefully someone would be generous enough to help me.

[orange]

What is the name of the table with the fields you identified?

I am looking for a way to find out which customers have bought a set of products

.

How do you define "set of products"?

[metube]

The table is named tblSalesbySalon

The feilds are:

ID
Date
ClientID
ProductID
SaleQTY
SaleAMNT

Ive tried using a crosstab query but can figure out the next step...Im sure im either on the wrong track or missing somthing.

Each product has an "ID"

so for example I want to see which customers purchases 1, 2 and 3...
Not filtering out the other transactions, but ultimatly counting the customers which purchased all three.