Access help

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

BTex

Thread Starter
Joined
May 10, 2002
Messages
564
I have two tables set up the same both are address database one old and one new , is it possible to let say compare first, name, and birth date, and if they don't match copy the non matching data from new to old?

RC
 
Joined
Jul 29, 2001
Messages
21,334
Tables in and of themselves are not databases, but what you want to do is quite possible. There is a wizard for creating a duplicates query that can them be used as a make table query.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
The way that I normally handle this is to create a field in both tables which combines the First, name and DOB and then set that field to Indexed with No Duplicates to get Individuality. Sometimes you have to add something like an SSSN number or address to give true Individuality to get the No Duplicates.
You obviously can't do that if it contains duplicates, which it shouldn't. If it contains duplicates you can create a Find Duplicates query to find them and remove them. Or create a copy of the table's structure only and set it's field to Indexed with No Duplicates.
If you can do the first part with the original table you just create an Append query to append the new table's data to the old one. Any duplicates are ignored.
If you have to use the second method because the first table already has duplicates you create an Append query for old & new tables to the new table.
 

OBP

Joined
Mar 8, 2005
Messages
19,896
Or you could use a Query as Rockn suggests, but I think you would need a Find Orphan query rather than a find duplicates query. Otherwise you need to use the Duplicates data to exclude the records to be appended.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top