W
WDSnews
I have two queries in which I expect to see a similar list of items yet one
result returns several more records than the seconds. I thought I could use
the Query Wizard's 'Find Unmatched Query Wizard' to make a list of
additional records. However the results of the wizard are always an empty
table. Thinking I did it wrong, I tried it again on two other queries in
which I knew there would be a difference and it also returned zero results.
So I have two questions.
Are queries not a legitimate source for an Unmatched (Is Null) operation?
How can I accomplish my goal?
result returns several more records than the seconds. I thought I could use
the Query Wizard's 'Find Unmatched Query Wizard' to make a list of
additional records. However the results of the wizard are always an empty
table. Thinking I did it wrong, I tried it again on two other queries in
which I knew there would be a difference and it also returned zero results.
So I have two questions.
Are queries not a legitimate source for an Unmatched (Is Null) operation?
How can I accomplish my goal?