A
AFSSkier
I have 2 tables tempBrand_Work_Table & Brand_Work_Table. I trying to run a
query to find the BrandID's that are "NOT LIKE" in the orginal table.
BrandID is a text field. I even tryed <> with the same results.
I can't get the resolutes I looking for with the following SQL:
SELECT tempBrand_Work_Table.[AP-Master], tempBrand_Work_Table.ItemNo,
tempBrand_Work_Table.BrandID, tempBrand_Work_Table.BrandName,
Brand_Work_Table.BrandID, Brand_Work_Table.BrandName
FROM tempBrand_Work_Table LEFT JOIN Brand_Work_Table ON
tempBrand_Work_Table.ItemNo = Brand_Work_Table.ItemNo
WHERE (((Brand_Work_Table.BrandID) Not Like [tempBrand_Work_Table]![BrandID]))
ORDER BY tempBrand_Work_Table.[AP-Master];
query to find the BrandID's that are "NOT LIKE" in the orginal table.
BrandID is a text field. I even tryed <> with the same results.
I can't get the resolutes I looking for with the following SQL:
SELECT tempBrand_Work_Table.[AP-Master], tempBrand_Work_Table.ItemNo,
tempBrand_Work_Table.BrandID, tempBrand_Work_Table.BrandName,
Brand_Work_Table.BrandID, Brand_Work_Table.BrandName
FROM tempBrand_Work_Table LEFT JOIN Brand_Work_Table ON
tempBrand_Work_Table.ItemNo = Brand_Work_Table.ItemNo
WHERE (((Brand_Work_Table.BrandID) Not Like [tempBrand_Work_Table]![BrandID]))
ORDER BY tempBrand_Work_Table.[AP-Master];