Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combine Fields in Query (2002 (XP))

    I want to take 2 fields strFirstName and strLastName and have them show together in a single field in my query. Is it Possible?

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Fields in Query (2002 (XP))

    Try this:

    Name: [strFirstName] & " " & [strLastName]

    This concatenates (&) the two fields ([ ]) with a space (" ") in between.

    Hope this helps

  3. #3
    Star Lounger
    Join Date
    Jan 2002
    Location
    Massachusetts, USA
    Posts
    87
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combine Fields in Query (2002 (XP))

    That did it, Thanks Mark

Posting Permissions

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