how to exclude certain information in a query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tara - 31 Aug 2006 21:14 GMT

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

Reply to this Message

Rick B - 31 Aug 2006 21:25 GMT

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

Signature

Rick B

>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

Reply to this Message

Jeff L - 31 Aug 2006 21:29 GMT

You set criteria on your fields in the query. Not sure how else to
assist you.

> 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

Reply to this Message