Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    santa clara
    Posts
    25

    Unanswered: Reports Combining Fields

    I'm creating a report and have separate fields, First_Name and Last_Name. On a report how can I combine them together? I tried First_Name & Last_Name but get error. Any help would be appreciated.

    Thanks.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Make sure you the control name isn't the same as one of your fields.

    Then try:

    =[First_Name] & " " & [Last_Name]

    Again, if the controls name is either first_name, or last_name, you'll get an error.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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