Querying 2 OR criteria

[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

 

[Guest]

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

 

[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

 

[punjab_tom]

Jet / MDB does not support having 2 OR criteria.

Sorry; move to SQL Server

 

[Guest]

I was wondering the same thing just last night

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