Bridget Doran
bridgetd at biostat.umn.edu
Wed Jun 2 12:04:06 CDT 2004
Susan: This is mostly the case. I have to clean up some bad design issues each time by pulling only the min date for each patient and the fields that go along with that. The design mixes data that should have been a separate table. I have no control over that. So yes, once I get only the records I need, it probably is a copy. But the table that is being created will have data added to it from other sources. So I would need to delete all the records from the data source I don't have control over first and then just append? Is that what you're saying? thanks Bridget Doran Biostatistics Consulting Lab University of Minnesota A444 Mayo Building 612.626.7009 bridgetd at biostat.umn.edu On Wed, 2 Jun 2004, Susan Harkins wrote: > 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 > > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >