Compare 2 or 3 tables

[Charles L. Phillips]

Hello,
I am using MS-Access 97. I have two (2) tables:

Customers:
FirstName
LastName
MiddleInt
Address

MailingList:
FirstName
LastName
Address

How do I compare TABLE1 (Customers) and TABLE2 (MailingList), then store the
difference (in this case, MiddleInt) into a third table3?

Or how do I compare the 2 tables, then save the difference into TABLE1
(Customers)???


Thank you,

 

[Guest]

1. Create a make-table query that creates Table3. Add Table1 & Table2 to it.
Join the three cognate fields, but output (check the box) only MiddleInt.
Now, I don't know what use a table would be that has only a middle initial,
and no other information.

2. Comparing Table1 & 2. By saving the difference, do you mean saving the
MiddleInt to Table1 for Customers that are on both lists, or saving all
Customers from MailingList to Customers if they are not already there?

If the former, create the MiddleInt field in Table1, then create an update
query that uses Table1 & Table2, joined on the three existing fields and that
updates Table1's MiddleInt entry (which is blank) to equal Table2's MiddleInt
entry.

If the latter, it gets a little more complex. You have to append from Table2
to Table1, but the source is Table1/Table2, joined as above, but with an
unequal join that shows ALL records in Table2 and only those in Table1 that
match, along with an IsNull in the criteria for the three fields above.

Whew...repost if you need some intermediate steps.

 

[Charles L. Phillips]

Hello,
"Thanks"...
I wasn't sure as, how to go about this, but you have give me a clear path...


Charles L. Phillips