how to exclude certain information in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have just one more question if anyone out there could please help answer. I
just need to know how to exclude certain information in a query. Thank you so
much
 
Use the word "not" before your criteria.

Please note, you will get much more specific answers if you tell us EXACTLY
what you want to do. For example....

I have a query with a "city" field. How can I exclude all records where the
city includes the word "St."?
- or -
I have a query with a date field. I need to exclude all the records where
the date is later than today.

etc...
 
You set criteria on your fields in the query. Not sure how else to
assist you.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query criteria - exclude data and return all records if null 3
Exclude items in a query 2
Query Criteria - EXCLUDE MULTIPLE? 3
excluding certain values from a query 5
Excluding data from a query 3
Multiple "Not Like" not working 5
query excluding listings from table 2
Exclude query data 2

Back
Top