I have created a report based on query where a new field was created called Full Name. It takes the first and last name fields from a table and combines them as Full Name.
My issue is: There are numerous spaces between the first and last names (example: Steve Jones). How can I elimanate the extra spaces?
Actual Entry: Full Name: [Participant Information].[First Name] & [Last Name]
Thanks.
My issue is: There are numerous spaces between the first and last names (example: Steve Jones). How can I elimanate the extra spaces?
Actual Entry: Full Name: [Participant Information].[First Name] & [Last Name]
Thanks.