Dave
I have been trying this in a different manner. 1st Query [W_JCR] I find all [USA #] with [Equip HB Name] like "*JCR*"
This part is simple.
Code:
SELECT DISTINCT Data.[Bumper # / Plat ID], Data.ID, Data.[USA #] AS USA
FROM Data
WHERE (((Data.[Bumper # / Plat ID])<>"") AND ((Data.[USA #])<>"") AND ((Data.[Equip HB Name]) Like "*JCR*") AND ((Data.[Row Type])="MEQUIP"));
Now I added a second query with the table [Data] and query [W_JCR]. I was hoping to use the first query to filter out all the [USA #] and list the remaining [USA #]
Code:
SELECT DISTINCT Data.[Bumper # / Plat ID], Data.[USA #]
FROM Data, [1-Data w_JCR]
WHERE (((Data.[Bumper # / Plat ID])<>"") AND ((Data.[USA #])<>[usa]) AND ((Data.[Row Type])="Plat"));
But it is not even close and lists all [USA #].
Please advise.
Thanks