Michael Barkemeyer
Member
- Local time
- Today, 09:06
- Joined
- Feb 2, 2020
- Messages
- 54
Hello,
Attached is a db which shows the results of a simple Unmatched Query. I am confused by the results. I would expect the query to return no records at all as the two tables are identical with regards to their record data.
It seems the query is picking up empty or null fields and treating them as if they had different data. How can I change the query def. so that in this case no records are picked up as being different?
I'm sure this will likely have a simple solution, but I can't seem to manage it.
Thank you.
Attached is a db which shows the results of a simple Unmatched Query. I am confused by the results. I would expect the query to return no records at all as the two tables are identical with regards to their record data.
It seems the query is picking up empty or null fields and treating them as if they had different data. How can I change the query def. so that in this case no records are picked up as being different?
I'm sure this will likely have a simple solution, but I can't seem to manage it.
Thank you.