Microsoft Access Developer Interview Question:

I have a database of sales broken out by state. How would I exclude a certain state or states from my query?

Submitted by: Muhammad

Finding records that match criteria is a common database function. To accomplish this specific query you can use the Not operator. For instance, if you want to find all your customers outside California, you might use the expression Not "CA" as your criterion.
Submitted by: Muhammad