Querying 2 OR criteria

R

Ramesh

How do I query for two criterias in different fields as an OR function?
Like i want to display all records where Status=AC OR Date is >(xdate).

when i give these criteria in the design view, it works as an AND function.

Any help please?

Thanks
Ramesh
 
J

JamesDeckert

If you put the two criteria on the same row it is an "And", if they are on
different rows it is an "Or". If you look under the Criteria row, I believe
the next row down shows "or".

James
 
R

Ramesh

Thanks James. that was so simple. I just assumed the Or was only for the
same column. I should have tried it out.

sorry for the dumb question.

Thanks for your patience.

Ramesh
 
S

scubadiver

I was wondering the same thing just last night


JamesDeckert said:
If you put the two criteria on the same row it is an "And", if they are on
different rows it is an "Or". If you look under the Criteria row, I believe
the next row down shows "or".

James
Click to expand...
 
Top