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
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