Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Pendleton, Indiana, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine 2 fields (2000)

    I have 2 fields, First Name and Last Name, how can I easily combine the 2 together. Oh what happened to the search feature????

    Thank you
    Trent

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Goose Creek, South Carolina, USA
    Posts
    108
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Combine 2 fields (2000)

    Try what's outlined in the attached QD sample
    Attached Files Attached Files

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Toronto, Ontario, Canada
    Posts
    314
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine 2 fields (2000)

    Trent,

    First of all... about the Search feature... see Post 250092

    As for the two fields being combined into one... use the Concatenation character -> & to create a string...
    (I don't know whether you are using this in code or a query or what... This is some standard code... )

    If FirstName is John and LastName is Doe, the syntax and results should look something like this:


    FullName = [FirstName] & " " & [LastName] ... That'll return "John Doe"
    or
    FullName = [LastName] & ", " & [First Name] ... That'll return "Doe, John"

    HTH

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    Pendleton, Indiana, USA
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine 2 fields (2000)

    Thank you both

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •