Or Statement

[Hawkide]

Access 97

I have a select query that returns data for a particular lab. I tried to change the criteria to return data for both Lab1 and Lab2.

If I change the first criteria line for the Lab field to "Lab1" or "Lab2" and get 9336 records

If I change the criteria so that the first criteria line say "Lab1" and the second criteria line says "Lab2" I get 9578 records

Can someone please explain why these are not returning the same thing.

 

[PHV]

Compare the SQL code of each try.
And what about a criteria like this ?
In ('Lab1','Lab2')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Hawkide]

Thank PHV...