Multiple Criteria

[Challseus]

Hi all:

I have a query where I have 4 different criteria to look for. The only thing is, I do not want it to only send back records that have criteria1 and criteria2 and criteria3, etc. I want it to send back records that have criteria1, or criteria2, or criteria3, etc.

Any help would be much appreciated.

 

[Joe4]

In the Query builder, if you put your criteria on different rows, it will treat it as OR. If you put them all on the same line, it treats it as AND.