I have two tables - the first is a list of projects with Project Numbers in the 'PROJ' field like this:
I want a query to filter this list of projects bby wildcards eg:
Not Like "FI*"
However I want to hold the list of wildcards in a seperate table (there are going to be multiple queries which need updating regularly, so I dont want to have to edit each query - I'd rather hold the list of wildcards as a separate table.
So I've tried doing this as a subquery like this:
SELECT DISTINCT PROJECTTABLE.PROJ
WHERE (((PROJECTTABLE.PROJ) Not In (Select [FILTERTABLE].[WILDCARD] from [FILTERTABLE])))
This doesnt work as the original project numbers dont match the filters, so it returns all projects.. What I need to do is make if 'Not Like' rather than 'Not In' but this returns an error.