DWUTKA at marlow.com
DWUTKA at marlow.com
Thu Jul 29 13:23:12 CDT 2004
Get rid of the MarrName field, and put [MarrName] in the Update To field under Surname. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of KathrynAtGwens Sent: Thursday, July 29, 2004 12:51 PM To: Access Developers discussion and problem solving Subject: [AccessD] Update query copy one field to another I'm just not getting it. Writing SQL statements is not coming to me, so explain this in what I type into the grid view. Table name - tblCemeteries4Updating Field name - Surname Field name - MarrName In the update query grid, I have Field MarrName Surname Table tblCemeteries4Updating tblCemeteries4Updating Update To What do I type into Update To grid in order to copy the contents of MarrName field into the Surname field? (I don't want to change the Surname field to MarrName, as I need both - after doing this copy, I have to manually go through and del the contents of MarrName from all the males, and add the correct MarrName to all the females, as all the existing contents are "maiden names"} -- Kathryn Bassett (at work address) kathrynatgwens at socal.rr.com kathryn at bassett.net (home) -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com