Results 1 to 3 of 3
  1. 08-11-2010, 04:21 PM #1
    Dega
    Dega is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Calgary, AB
    Posts
    73

    Concatenate firstname + lastname

    I need to concatenate two fields "firstname + lastname" but uncertain of the syntax.



    Expr2: [Forms]![frmCustomers]![firstname] + ???

    Thank you.
    Reply With Quote Reply With Quote
  2. 08-11-2010, 04:54 PM #2
    pbaldy's Avatar
    pbaldy
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Try

    Expr2: [Forms]![frmCustomers]![firstname] & " " & [Forms]![frmCustomers]![lastname]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com
    Reply With Quote Reply With Quote
  3. 08-11-2010, 04:58 PM #3
    Dega
    Dega is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Calgary, AB
    Posts
    73
    Thank you!
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. How to Concatenate String Criteria
    By ColPat in forum Programming
    Replies: 2
    Last Post: 06-26-2010, 08:48 PM
  2. Concatenate Values from within the same column
    By ColinISL in forum Access
    Replies: 3
    Last Post: 10-16-2009, 09:27 AM
  3. Concatenate Formula
    By Shingo in forum Programming
    Replies: 1
    Last Post: 07-25-2009, 09:14 AM
  4. Need Code to Concatenate All Records
    By menntu in forum Programming
    Replies: 4
    Last Post: 06-05-2009, 09:43 AM
  5. concatenate string using loop
    By nengster in forum Programming
    Replies: 0
    Last Post: 02-23-2009, 08:05 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums