Results 1 to 2 of 2

Thread: Crystal Reports Question

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2004
    Posts
    11

    Crystal Reports Question

    I have a query in MS Access where I combine the First_Name and Last_Name into a field called Name.

    But when I'm using Crystal Reports the Name's do not show up. I'm doing this for City, State Zip too. How can I get this to work?

    Thanks in advance

  2. #2
    New Member
    Join Date
    May 2004
    Posts
    5
    Try to use original fields and concatenate them in your report using Formula fields.

    formula={table1.FirstName} & " " & {table1.LastName}

    That will work 100%


    Cheers

Posting Permissions

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



Click Here to Expand Forum to Full Width