Experts, I have been having troubles with these queries. I dont know what I am doing wrong. It is quite simple but something seems to not be working.
If you look at the pared down db.
Open the query
It shows 2 records that are NOT IN tblLetterOfCredit on LCNo and L/C Ref
However, both of those records are in tblLetterOfCredit.
The only difference between them is a "-" dash but the function (StrippedChar) is suppose to remove the "-" and compare but the query still shows those 2 records as NOT IN tblLetterOfCredit.
What is happening? These queries are about to drive me nuts because I think I understand what is happening but then what I learned goes out the window (as in this example).
Please open the pared down db. There is probably a simple answer to this that I cant see. EE.accdb
What makes it a RIGHT or LEFT qry? In the query code above, there is not line drawn between the two tables but I do see it is a RIGHT join. Maybe it doesnt show the line because of the error?