Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Concatenating Text 1

Status
Not open for further replies.

rcorbett

Instructor
Nov 25, 2002
24
US
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.

 
Have you tried:

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

That'll force only one space between the two names
 
Beeps thanks for the info - tried it but it still has the spacing issue.
 
maybe:

Full Name: Trim([First Name]) & " " & Trim([Last Name])
 
Beeps - it works, thanks for the lesson.

Robert.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top