Unmatched query not working (1 Viewer)

[chthomas]

can someone tell me why my "Unmatched Query" results are not showing correctly though there are unmatched records?

Am trying to find the unmatched records between 2 queries, say "MTOSelect" query and "SPECSelect" query. Am using the expression Check1 and Check2 in both the queries for comparison. If a combination of "Pipclass & ShortCode & Size1 & Size2", which is Check1 and Check2 of both the queries do not match then it should be shown. Am using an extra "&" symbol when combining fields just to make sure that they don't overlap with the data.

Am attaching my sample db.

Regards,

charley

 

[___]

I think it's because you have a one to one link in the MtoSpecSelect Query.

HTH