Query for multi criteria

[Erictsang]

Dear all

I have a some trouble in using the Queries

I have the following criteria



a) <> cancelled
b) [product 1] > or = 1
c) [product 2] > or = 1

I try to place the above in

a) in the Criteria as it is a must
b) and c) is either or .. how can i do that

Eric

[June7]

Maybe:

WHERE [fieldname] <> "cancelled" AND ([product1] >= 1 OR [product2] >= 1)