[AccessD] Update Query?

A few questions.  Do you have a Date/Time field that records when a record
is created?  Do you have a field that is used to determine when the last
change to that record was made?

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Bridget Doran
Sent: Wednesday, June 02, 2004 11:23 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Update Query? 


Hi all,

I will be pulling  a table on a monthly basis from another access
database. Initially, I make a new table with these records. Then monthly,
I want to update the new table with only records that have changed from
their original source or new records that have been added.

Is this a simple query?

Thanks for any help.

Bridget Doran


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com