Results 1 to 2 of 2
  1. #1
    2 Star Lounger bmeacham's Avatar
    Join Date
    Jan 2001
    Location
    Austin, Texas, USA
    Posts
    191
    Thanks
    4
    Thanked 4 Times in 4 Posts

    Query syntax (2K SR1)

    I have a table that contains (among other things) two fields, FirstName and LastName. I want to query the table and return a single column that contains a string consisting of FirstName + " " + Lastname. Can someone tell me the SQL syntax to do this in Access 2000?
    Bill Meacham
    bmeacham98 AT yahoo.com

  2. #2
    New Lounger
    Join Date
    Apr 2003
    Location
    Cleveland, Ohio, USA
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Query syntax (2K SR1)

    Try this!
    Wish you well!

    SELECT Trim([firstname] & " " & [lastname]) AS Name
    FROM Student_Data;

    Bill

Posting Permissions

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