Comparing table data and adding differential information

  • Thread starter Thread starter Adam-Network Admin
  • Start date Start date
A

Adam-Network Admin

Aappend queries allow you to add entire records to a table from a source.
Delete queries allow you to delete entire records.
Update queries allow you to update information on one table from information
on another.

How would I compare two tables and add just the records to one exist on the
other without adding every other record again. For example A has 400 records
and B has 399. I want to compare both tables to find the missing record and
add it to B to make B 400 records, not 799 records. How is this accomplished?

Thank You
Adam
 
If your TableB has a unique (i.e., no duplicates) row identifier, and if
TableA uses the same ID number, when Access tries to append records, it
refuses to append any record for which the ID already exists.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.
 
Back
Top