Hello,
im building a query and I have two tables. I’m trying to use the data in my second table to eliminate the records I don’t want to see in the first table. I have added the corresponding field to the grid and put the following in as my criteria.
Not Like “*” & [tblone]![fieldone] & “*”
and it returns all the records duplicated many times.
As a test I used:
Like “*” & [tblone]![fieldone] & “*”
and it returns only the results that I don’t want to see, which is what I’m trying to eliminate from the results.
i tried joining the fields all three ways, fail.
i tried both long and short text as field types, fail.
i tried not using the second table and using, in the criteria field, Not Like “example01” And Not Like “example02”, etc, for each piece of criteria and the statement is too long and is truncated, fail.
i also tried Not Like “*” & [tblone]![fieldone] & “*” Or Is Not Null, fail
any help would be appreciated.
manoman