[AccessD] Append/Update tables

http://www.peterssoftware.com/trm.htm

...hth :)

William

----- Original Message ----- 
From: "John Eget" <joeget at vgernet.net>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Monday, January 02, 2006 9:29 AM
Subject: [AccessD] Append/Update tables


>I have a table "tblPA" in a database and have successfully imported the 
>same file from another database.  So now I have "tblPA" and "tblPA1".  The 
>tables have 4 identical fields called "Added Date", "Added Time", "Date 
>Modified", and "Time Modified" plus several others.
>
> I would like to append/update the "tblPA" by adding the new records from 
> the "tblPA1" and append/update the records of "tblPA" if the table 
> "tblPA1" has a later modified date and time.
>
> First, I think I need to delete the records that need to be 
> appended/updated from "tblPA" and then just add the records from "tblPA1" 
> that are new.  That may all be possible by the Date and Time Modified 
> fields and then just using the Added date and time to add the records to 
> "tblPA"
>
> I do believe that that will satisfy the process.  Do you agree? Have an 
> example? Know where there is an example?
>
> Thanks again
>
> John
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>