[AccessD] Update Query?

Bridget -- it sounds like you're just making a copy of a table with all its
contents to me. Is this correct? If you're updating changes and adding new
records, it sounds like an exact copy in the end. 

Susan H.  

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bridget Doran
Sent: Wednesday, June 02, 2004 12:23 PM
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