Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Space betwen Name and Surname

Discussion in 'Information Technology' started by kuben@angelus.co.za, Oct 30, 2005.

  1. kuben@angelus.co.za

    kuben@angelus.co.za
    Expand Collapse
    Guest

    Hi

    I have two fields [Name] and [Surname]. What I insert this on a report
    I would like the name and surname to be side-by-side without any extra
    space between.

    I don't know if this makes sense??

    Kuben
    South Africa
     
  2. Loading...

    Similar Threads Forum Date
    Sikhi Gurdwaras Throw Open Their Spaces, Langar For Stranded Commuters In Haryana Sikh Sikhi Sikhism Feb 23, 2016
    SciTech Urgent Need to Remove Space Debris Breaking News Apr 25, 2013
    India Panthic space shrinking within Akali Dal; more Hindus for parliament Breaking News Mar 28, 2013
    Prayer / Simran Space Questions and Answers Jun 1, 2012
    SciTech Stephen Hawking: Colonize Space or End the Human Race Breaking News Jan 9, 2012

  3. Ofer

    Ofer
    Expand Collapse
    Guest

    Create a field in the report and in the control source you can write
    =[Name] & [SurName]
    --
    Good luck



    "kuben@angelus.co.za" wrote:

    > Hi
    >
    > I have two fields [Name] and [Surname]. What I insert this on a report
    > I would like the name and surname to be side-by-side without any extra
    > space between.
    >
    > I don't know if this makes sense??
    >
    > Kuben
    > South Africa
    >
    >
     
  4. fredg

    fredg
    Expand Collapse
    Guest

    On 29 Oct 2005 07:07:35 -0700, kuben@angelus.co.za wrote:

    > Hi
    >
    > I have two fields [Name] and [Surname]. What I insert this on a report
    > I would like the name and surname to be side-by-side without any extra
    > space between.
    >
    > I don't know if this makes sense??
    >
    > Kuben
    > South Africa


    Use an unbound control in the report.
    Set it's Control Source to:
    =[FirstName] & " " & [Surname]

    Note 1: I assume you do want at least one space between the names.
    Note 2: Name is a reserved Access/VBA/Jet word and should not be used
    as a field name.
    For additional reserved words, see the Microsoft KnowledgeBase article
    for your version of Access:

    109312 'Reserved Words in Microsoft Access' for Access 97
    209187 'ACC2000: Reserved Words in Microsoft Access'
    286335 'ACC2002: Reserved Words in Microsoft Access'
    321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Ofer" <Ofer@discussions.microsoft.com> wrote in message
    news:1A935A62-877A-4859-8B1B-F277C880C1A3@microsoft.com...
    > Create a field in the report and in the control source you can write
    > =[Name] & [SurName]


    Ofer, you forgot the space -- =[Name] & " " & [SurName]

    I know you knew this and just typed too fast...
     
  6. Ofer

    Ofer
    Expand Collapse
    Guest

    Thanks Larry,
    I didn't forget, I got confused because Kuben asked to have no extra space
    between the two fields.
    After Fred replied I realized my mistake.



    "Larry Linson" wrote:

    >
    > "Ofer" <Ofer@discussions.microsoft.com> wrote in message
    > news:1A935A62-877A-4859-8B1B-F277C880C1A3@microsoft.com...
    > > Create a field in the report and in the control source you can write
    > > =[Name] & [SurName]

    >
    > Ofer, you forgot the space -- =[Name] & " " & [SurName]
    >
    > I know you knew this and just typed too fast...
    >
    >
    >
    >
    >
     

Share This Page