C
creedmaniac97
I have two tables in an access database...
one is an archive table and the second is updated weekly with new info
(names and dates...can't give anymore info than that for the info
[military/confidential].
The weekly updates usually contain duplicates that are already in the
archive table. I am looking for a way to automatically update the archive
table using the only the records in the weekly table that are not in the
archive table yet.
The problem is that there are four main columns in both tables...name, start
date, stop date, and remarks
There can be the same name with two different stop dates...if this is the
case when the new table updates the archive...i would need it to show both of
those (which eliminates using only the name to delete duplicates) I know
that i can use an ammend query to get rid of duplicate names...but i need it
to cross reference the names and the dates to make sure they are all the same
before it is deleted....example below...
Archive table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..done
weekly table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..none
daniel barr start--3 mar 05 stop 4 jul 05 remarks..none
(what archive should say upon update)
archive table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..done
daniel barr start--3 mar 05 stop--4 jul 05 remarks..none
one is an archive table and the second is updated weekly with new info
(names and dates...can't give anymore info than that for the info
[military/confidential].
The weekly updates usually contain duplicates that are already in the
archive table. I am looking for a way to automatically update the archive
table using the only the records in the weekly table that are not in the
archive table yet.
The problem is that there are four main columns in both tables...name, start
date, stop date, and remarks
There can be the same name with two different stop dates...if this is the
case when the new table updates the archive...i would need it to show both of
those (which eliminates using only the name to delete duplicates) I know
that i can use an ammend query to get rid of duplicate names...but i need it
to cross reference the names and the dates to make sure they are all the same
before it is deleted....example below...
Archive table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..done
weekly table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..none
daniel barr start--3 mar 05 stop 4 jul 05 remarks..none
(what archive should say upon update)
archive table
daniel barr start--4 feb 05 stop--2 mar 05 remarks..done
daniel barr start--3 mar 05 stop--4 jul 05 remarks..none