Results 1 to 5 of 5
  1. #1
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60

    merge two fields at one in report

    How to merge two fields at one in report

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    One way:

    =FieldOne & FieldTwo
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    Quote Originally Posted by pbaldy View Post
    One way:

    =FieldOne & FieldTwo
    I do it, but it prints "#error" at that column
    I want first name and last name merge with each others
    Last edited by msasan1367; 03-30-2013 at 12:32 AM.

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    Did you use your actual field names, and make sure no textbox has the same name?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    msasan1367 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Feb 2013
    Posts
    60
    Quote Originally Posted by pbaldy View Post
    Did you use your actual field names, and make sure no textbox has the same name?
    ok, that's solved

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

Similar Threads

  1. Merge fields (not concatenate)
    By sberti in forum Access
    Replies: 2
    Last Post: 11-30-2012, 12:53 AM
  2. merge two fields in access? how to ?
    By vivah in forum Queries
    Replies: 6
    Last Post: 07-23-2012, 10:02 AM
  3. Replies: 3
    Last Post: 03-27-2011, 03:02 PM
  4. Word Merge Report
    By Wayne311 in forum Reports
    Replies: 13
    Last Post: 02-21-2011, 12:03 AM
  5. Merge two fields
    By daviddoria in forum Access
    Replies: 0
    Last Post: 01-31-2009, 09:12 AM

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