[AccessD] Save a concatenate to another field

Hi Kathryn,

You could use an update query.  Air code, something like:

UPDATE tblMyNewTable
SET tblMyNewTable.NewTitle  = [tblOld].[TitleProper]& " " & [tblOld].[SecondaryTitle] & " " & [tblOld].[SubTitle]
WHERE tblOld.TitleID = tblMyNewTable.TitleID

Should get you close.

Cheers
Darryl.



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
Sent: Tuesday, 25 February 2014 4:27 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Save a concatenate to another field

On this page: http://www.techonthenet.com/access/functions/string/concat.php
I followed the example at the bottom, and have

Expr1: [TitleProper]& " " &[SecondaryTitle] & " " & [SubTitle]

But how do I get the results into the new field I have called Title? (So I can dump TitleProper, SecondaryTitle, and SubTitle)


--
Kathryn Rhinehart Bassett (Pasadena CA)
"Genealogy is my bag" "GH is my soap"
kathryn at bassett.net
http://bassett.net   



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com