DWUTKA at marlow.com
DWUTKA at marlow.com
Wed Jun 2 12:10:50 CDT 2004
I would have to go with what Susan said then, since the end result is that you have a 'new' copy of the data. The issue there is, that you now are overwriting 'extra' data, which is going to bloat the size of your database. You'll need to compact the database more often. 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:57 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Update Query? No and No. I have no control over the source data. I can put those fields into the new table I am creating from this data but I don't think that's what you're getting at. Our client will be using the demographic data from this institution (source data that I have no control over) and then adding to the created table similar data from other institutions that they(the client) will do the data entry on. Bridget Doran Biostatistics Consulting Lab University of Minnesota A444 Mayo Building 612.626.7009 bridgetd at biostat.umn.edu -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com