chthomas
Registered User.
- Local time
- Today, 12:43
- Joined
- Feb 8, 2000
- Messages
- 32
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
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
