Concatenating Text 1

[rcorbett]

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.

 

[Beeps]

Have you tried:

Full Name: [First Name] & " " & [Last Name]

That'll force only one space between the two names

 

[rcorbett]

Beeps thanks for the info - tried it but it still has the spacing issue.

 

[Beeps]

maybe:

Full Name: Trim([First Name]) & " " & Trim([Last Name])

 

[rcorbett]

Beeps - it works, thanks for the lesson.

Robert.

 

[Beeps]

No problem,

glad it helped!