Wildcard Table

[genedi]

Hi,

I have created a table of entries I would like to use as exclusions. I want to create a query that uses this table as wildcards and excludes any fields that have this entry.


Example: I want my query to use the above table and use it as a wildcard to exclude any fields that have "$", "Auditor", "Train",etc....



I'm trying to use a table dynamically rather then using the Not Like function.




Any help would be greatly appreciated.

Thanks,

Gene.

[June7]

Well, criteria parameters do not 'exclude fields' - they exclude records.

[Homegrownandy]

I think he meant records not fields. Not sure though.

[orange]

genedi,

The responses so far tend to indicate that your post is not clear. You mention fields, but responses talk records.
Using an exclusion table approach usually involves values in certain field; Not a character or string within a field.
see this example

[June7]

Maybe:

SELECT Table1.*, Table2.* FROM Table1, Table2 WHERE Table1.fieldname NOT LIKE "*" & Table2.fieldname & "*";