Joined: 02 May 2011
Location: United States
Online Status: Offline
Posts: 28
Topic: Combine multiple fields into one Posted: 02 May 2011 at 7:39am
Hello.
I need some help please. Do you know how I can get data from multiple fields to merge into one. I know how to do it in Access, I just can't figure it out in Crystal.
Here is what I need.
Employee Name: Trim([LAWSON_EMPLOYEE]![LAST_NAME])+", "+Trim([LAWSON_EMPLOYEE]![FIRST_NAME])+" "+[LAWSON_EMPLOYEE]![MIDDLE_INIT]
Employee Name: is the title I need to have the information placed under.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum