On Wed, 15 Apr 2009 11:12:35 -0700 (PDT),
(E-Mail Removed) wrote:
>On Apr 15, 1:36*pm, John W. Vinson
><jvinson@STOP_SPAM.WysardOfInfo.com> wrote:
>> On Wed, 15 Apr 2009 07:06:25 -0700 (PDT), ecle...@gmail.com wrote:
>> >What is the easiest way to find the inverse of matching fields?
>>
>> Please explain what you mean by "differences" and "inverse". Perhaps an
>> example of your data would help. As posted the question is really ambiguous...
>> --
>>
>> * * * * * * *John W. Vinson [MVP]
>
>If you drag a field from one table to another in a query, you get the
>matches. I want to find the records that do not match instead.
>Thanks.
So if you have 100 records in TableA, and 200 records in TableB, and none of
them match, you want to see all 20,000 mismatches? The first record in TableA
is not equal to any record in TableB, so you will see all 200 as "records that
do not match".
Reading behind your literal words, if you want to see that subset of the
records in TableA which have no matching record in TableB, then Golfinray's
suggestion is exactly correct: create a new Query, and use the "Unmatched
Query Wizard" to create it.
--
John W. Vinson [MVP]
Similar Threads
