how to exclude certain information in a query

T

Tara

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
 
R

Rick B

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...
 
Top