Microsoft Access Developer Question:
Download Job Interview Questions and Answers PDF
I have a database of sales broken out by state. How would I exclude a certain state or states from my query?
Answer:
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.
Download Microsoft Access Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you tell me At Least Six File Extensions Of Microsoft Access? | Tell us why has a relationship shown as 1:1 when I was expecting 1:∞? |