austenr
10-11-2006, 07:14 PM
I am trying to check for multiple criteria to exclude those records in a design view query. For instance I want to exclude records for a field that are <> "Jones" or <>"Smith". I have tried to do just one and it ends up including the records anyway. I have even tried using the builder when you right click or criteria.
What is the correct way to exclude the above? I can do it in SQL Server but need it to work in ACCESS. Thanks. :banghead:
What is the correct way to exclude the above? I can do it in SQL Server but need it to work in ACCESS. Thanks. :banghead: