[AccessD] Save a concatenate to another field

Wish I could get a copy of Access to have a look at this, only got open
office as can't afford to buy Office as unemployed, definitely have to
start up my own business or rob a bank.

Have you checked to see that there aren't any hidden characters etc in the
two fields that you are trying to concatenate, what are the errors you are
getting ?

Paul


On 25 February 2014 06:17, Kathryn Bassett <kathryn at bassett.net> wrote:

> 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
>



-- 
Paul Hartland
paul.hartland at googlemail.com