[AccessD] Save a concatenate to another field

Kathryn Bassett kathryn at bassett.net
Tue Feb 25 01:12:29 CST 2014


That didn't work.
BTW, there are no TitleProper's that are Null, just SecondaryTitle &
SubTitle

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Stephen Bond
> Sent: 24 Feb 2014 9:49 PM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Save a concatenate to another field
> 
> Make an update query with one field, Title.
> 
> In the 'Update To' row, put : [TitleProper]& " " & [SecondaryTitle] & " "
&
> [SubTitle]
> 
> A thought - if [TitleProper] is Null you'll get a leading space in the
[Title] field.
> You might want to investigate using the + concatenation operator instead
of
> the &. For example, ([TitleProper] + " ") will evaluate to Null when
> [TitleProper] is Null
> 
> Stephen Bond
> Invercargill, NEW ZEALAND
> 
> 
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:accessd-
> bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
> Sent: Tuesday, 25 February 2014 6:31 p.m.
> To: Stephen
> 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
> 
> 
> 
> --
> 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