I have been working on a Query to sort through a list of companies. I am trying to query the company name to include ALL entries that have the include key(from another table) anywhere in their company name... It is supposed to exclude all entries with ONLY the exclude key(from another table)... If it has the exclude key AND the include key or neither key then the entry should be included... Then it is supposed to use all of the entries added from the previous sorts and include ONLY the entries where the zipcode matches one from a ZIPCode list.

Below I have listed the tables with their variables and my attempt on the query:

Include Table (tblinc)
ID
Inckey

Exclude Table (tblex)
ID
exkey

List Table (list)
ID
Company
Address
City
State
ZIPCode
…

ZIPCode Table (ZIPCode)
ID
ZIPCode

Query withZips <--- my attempt... doesnt work 100% ALOT OF REPETITIVE ENTRIES

SELECT DISTINCT tblinc.inckey, tblex.exkey, ZIPCode.ZIPCode, *
FROM ((list LEFT JOIN tblinc ON list.company Like "* " & tblinc.inckey & " *") LEFT JOIN tblex ON list.company Like "* " & tblex.exkey & " *") INNER JOIN ZIPCode ON list.ZipCode Like "*" & ZIPCode.ZIPCode & "*"
ORDER BY inckey DESC , exkey;

This has become urgent... If you can help, please respond asap...

One or more of your joined tables has many records. That is, the joins are one-to-one, but are one-to-many.