Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2005

Tip: Looking for answers? Try searching our database.

filter on multiple terms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
timg - 04 May 2005 17:08 GMT
I have a database of company names, and i need to filter out certain names
that are franchises etc, such as Wendy's and Kroger.  I would like the filter
to be a list of names that could be 10 or 12 entries long, but I cannot use
NOT LIKE on more than one entry apparently.  is there a way to do this?
Duane Hookom - 04 May 2005 17:30 GMT
I would create a table of key words to store values like Wendy's,... For
instance using the Customers table in Northwind:
Create a table "tblKeyWords" with a single text field "KeyWord". Add key
words of "Manager" and "Sales". Then create a query with SQL of:

SELECT Customers.*
FROM Customers
WHERE (((Customers.CustomerID) Not In (Select CustomerID FROM Customers c,
tblKeyWords k WHERE c.ContactTitle like "*" & k.KeyWord & "*")));

This will display all the customer records where Manager and Sales are not
in the ContactTitle field.

Signature

Duane Hookom
MS Access MVP
--

>I have a database of company names, and i need to filter out certain names
> that are franchises etc, such as Wendy's and Kroger.  I would like the
> filter
> to be a list of names that could be 10 or 12 entries long, but I cannot
> use
> NOT LIKE on more than one entry apparently.  is there a way to do this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.