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
 
S

strive4peace

Hi Ramesh,

you can do one of two things:

1. in criteria under the field with 2 possible values, combine them with OR:
x OR y

2. repeat criteria for single field (z) on both criteria rows

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
R

Ramesh

Thanks Crystal.

Ramesh

strive4peace said:
Hi Ramesh,

you can do one of two things:

1. in criteria under the field with 2 possible values, combine them with
OR:
x OR y

2. repeat criteria for single field (z) on both criteria rows

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
S

strive4peace

you're welcome, Ramesh ;) happy to help

Warm Regards,
Crystal
*
:) have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top