Arthur Fuller
artful at rogers.com
Thu Jun 3 20:54:19 CDT 2004
AFAIK you cannot do an update and an insert in a single query -- and even if you could, I would dispute its soundness. I prefer atomic actions -- hit one table in exactly one way. This translates to -- upate the existing rows first, then do the inserts. Two actions, each atomic. Wrap them if you want. Arthur -----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:57 PM 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