November 7, 200520 yr Hi All, I'm pretty sure this can be done, but this is new to me. When I get my raw data from an Excel spread sheet I have 2 fields for name: First Name Last Name Is there a way in FMP that I can combine the two fields into 1 so the result equals: Field Name = "Full_Name" result = Last_Name, First_Name Thanks for any help! Steve
November 7, 200520 yr That is the way it should be. Add a new calculation text field Full_Name = Last_Nam,e & ", " & First_Name.
November 7, 200520 yr Author Thank you! That was easy and I should have thought of that myself! I need to learn how to think these things through better. All part of the continuous learning curve with this amazing software. Steve
Create an account or sign in to comment