[AccessD] Save a concatenate to another field

Got it - wonderful !!
When I first opened the query in design view I was thrown because I didn't
see anything. I'm not well-versed in writing directly in SQL. But when I
changed to SQL view, I saw what you wrote. I will keep this version of the
database to use as an example. I've now copied it into the original and
updated it.

Thank you so much!
Kathryn

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Stephen Bond
> Sent: 24 Feb 2014 11:19 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Save a concatenate to another field
> 
> 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.acc
> db
> 
> 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
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com