Results 1 to 2 of 2
  1. #1
    LAazsx is offline Advanced Beginner
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Nov 2010
    Posts
    30

    Combining values of 2 columns into one string

    Hi, I have 2 columns, namely LastName and FirstName. Is there a way such that when the data is shown, the values of the two column appear in a single string by separated by a comma? Like Rodriguez, Sam

  2. #2
    ssanfu is offline Master of Nothing
    Windows 2K Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Sure.

    In your query, go to a blank column and enter

    FullName: [LastName] & ", " & [FirstName]


    In SQL view it would look like

    SELECT [LastName] & ", " & [FirstName] as FullName, {more fields} FROM TableName


    In the Control Source of a text box on a form you could use (if the form record source had the two fields):

    = [LastName] & ", " & [FirstName]

    I perfer the first option....

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Split string into Date and Time Columns?
    By Hobbes29 in forum Queries
    Replies: 2
    Last Post: 06-08-2010, 06:50 PM
  2. Replies: 1
    Last Post: 10-09-2009, 11:52 AM
  3. Replies: 1
    Last Post: 10-01-2009, 06:41 AM
  4. Combining columns into rows
    By steeveepee33 in forum Queries
    Replies: 5
    Last Post: 04-30-2009, 09:18 PM
  5. Replies: 1
    Last Post: 06-21-2007, 01:02 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums