[AccessD] Save a concatenate to another field

Stephen Bond stephen at bondsoftware.co.nz
Tue Feb 25 01:19:16 CST 2014


Kathryn

I downloaded and built an update query.  The SQL is

UPDATE Genealogies SET Genealogies.Title = [TitleProper] & " " &
[SecondaryTitle] & " " & [SubTitle];

This works for me.  I have uploaded your db with Query to SendSpace, you
should get a notification.  


Stephen Bond




-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn
Bassett
Sent: Tuesday, 25 February 2014 7:31 p.m.
To: Stephen
Subject: Re: [AccessD] Save a concatenate to another field

I get errors. Here's the database:
https://www.dropbox.com/s/iwqoor4rwd2o8hg/ConnerBishopHistories.accdb

Run the Genealogies query. ID 349 is the first record I'm trying to
concatenate. I see the results in the Expr1 field. I want to put that
concatenated info into the Title field.

Don't be concerned with the other tables, and yes, I know the whole db
is
not properly titled (like tblGenealogies etc) and it's all flat vs
relational, but that is something for down the road. Right now this is
what
I've go to work with.

I know I need to make it an update query, I just need the right SQL to
do
what I want.

Kathryn

> -----Original Message-----
> 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.

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





More information about the AccessD mailing list