[AccessD] Update query copy one field to another

Thanks - I had it backwards - just wasn't getting it.

Kathryn

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> DWUTKA at marlow.com
> Sent: Thursday, July 29, 2004 11:23 AM
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Update query copy one field to another
> 
> 
> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com