Re: String Concatenation

Rebecca Smith wrote:
> In past versions of Access it was a simple matter to create a persons
> full name from the three strings 'FirstName' 'MiddleInit' and
> 'LastName' and include a period after the middle initial. Using a
> plus sign before the middle initial kept the period from showing up
> if the middle initial was blank. Seems Access 2003 doesn't recognize
> this simple trick.
>
> So the question is, how do create a full name in a query without
> having a period show up between FirstName and LastName if there is no
> middle name?

Something else is going on because there is no change to Access 2003
affecting how the + and & operators work with respect to Null propogation.
I just performed the following test in the immediate window of Access
2003...

?"test" & ("." & Null) & "TEST"
test.TEST

?"test" & ("." + Null) & "TEST"
testTEST

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Beginner needs help with text files
    ... Everything I am reading pertains to finding directories or files not finding ... to actually perform the extract function? ... I just need to search within the zip to find the strings that ... I don't think that will matter though. ...
    (microsoft.public.vb.general.discussion)
  • Re: New
    ... >> in part on how it's taught. ... using pointers and null-terminated strings instead of the ... actually do matter) is one of the ... and a competent C++ programmer ...
    (comp.programming)
  • Re: Dumb Planet Waves Humidifier Questions
    ... without incident. ... It is not a matter of being cheap or lazy, ... No I don't wipe my strings because it doesn't affect the longevity at ... time spent changing them - based on ...
    (rec.music.makers.guitar.acoustic)
  • Re: Changing strings
    ... It's not a matter of time. ... It's a matter of how much they are played, storage, keeping them clean, how ... You need to learn how to change the strings yourself. ... If you have locking pegs, ...
    (alt.guitar.beginner)
  • Re: String Concatenation
    ... Rebecca Smith wrote: ... name from the three strings 'FirstName' 'MiddleInit' and 'LastName' and include a period after the middle initial. ... Seems Access 2003 doesn't recognize this simple trick. ... how do create a full name in a query without having a period show up between FirstName and LastName if there is no middle name? ...
    (comp.databases.ms-access)