Multiple requirement in Queries

[Erictsang]

Dear

I have a question which i fail in Query

I have a make a query to select clients that purchase only selected items in a shopping list of 10 choice

as if client select the item, it just shows "1"

i want to check, what the client puchased or which item he checked "1"


In Query


[item 1] [item 2] [item 3] [item 4]
Criteria >1
or >1 >1

How should i do that ?

Eric

[ranman256]

make Q1, to count the 1s.
select clientID from tShopping where [Qty] =1

then make Q2:
use Q1 to pull the clients
select tClients.* from tClients,Q1 where Q1.clientID =tClients.clientID