Multiple OR criteria along with other AND criteria

R

Ramesh

Hi

I am trying to make a query where i am specfying multiple criteria ... where
field A fulfils condition x or y AND field B fulfils condition z. in the
design view, when i put x and y in two different rows, then it becomes (x
AND z) or y. Whereas i need (x OR y) AND z. my guess is there must be some
way to put x and y in the same row as OR.

any help on resolving this please.

Thanks
Ramesh
 
Top