Problem with finding unmatched records in two tables.

[basara]

hi,

I have two table called POP and CurrMth, these two tables have some common
fields called [disty] [part] and [custumer]. I want to find the unmatched
records from these two table according to the combination of the three
fields, meaning find in table POP the records which the combination of
[disty] [part] and [customer] is different from CurrMth.

I know there is a special query called find unmatched records. However,
there is not a Primary key in both of my table so that i need to check for
the combination of the three fields. Moreover, my [customer] can be null.

Can someone please help.....
Thanks in advance

Basara

 

[basara]

Do You mean I combine the three field into one then try to compare? But how
do i output the unmatched? Do I use the find Unmatched Qery and set the
matched field to be check1 and check2?
gonna try it now.
--
someone in trouble

hi,

I have two table called POP and CurrMth, these two tables have some
common fields called [disty] [part] and [custumer]. I want to find
the unmatched records from these two table according to the
combination of the three fields, meaning find in table POP the
records which the combination of [disty] [part] and [customer] is
different from CurrMth.

I know there is a special query called find unmatched records.
However, there is not a Primary key in both of my table so that i
need to check for the combination of the three fields. Moreover, my
[customer] can be null.

Can someone please help.....
Thanks in advance

Basara

As I recall, you can create a field lets call it check1 and check2
consisting of the three fields you want to check on.

Check1:[disty] & [part] & [custumer]