I have a database of sales broken out by state. How would I exclude a certain state or states from my query?
Submitted by: MuhammadFinding 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
Submitted by: Muhammad
Read Online Microsoft Access Developer Job Interview Questions And Answers
Top Microsoft Access Developer Questions
| ☺ | Tell us what property does every object in MS Access have? |
| ☺ | What are managing Data Tasks? |
| ☺ | Tell us how Do You Create An Append Query? |
| ☺ | Tell us About The Various Features Present In Ms Access? |
| ☺ | Tell us what format should my database be saved in to allow different versions of Microsoft Access to open the database? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Sybase Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
