I've created a query the captures the item#, Buyer name, pack size, and item weight. The purpose to the query is to display items that exceed a certin weight, however I need to exclude certain items that have certin words in the description field ex. all shrimps from the description field. Is there a command that allows u to exclude certain records? All help is greatly appreciated.... thanxs
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excludng results from a query
- Thread starter gusc999
- Start date
HarleyQuinn
Programmer
How about:
Hope this helps
HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
Code:
Where YourField NOT LIKE "*shrimp*"HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin
Get the most out of Tek-Tips, read FAQ222-2244 before posting.
- Status
Similar threads
- Question