Join First and Last Names

[Dandy55]

On my form and table, I have separate fields for firstname and lastname. On my report based on the form, I would like to concatenate these names into one full name, but keep getting an error. Does anyone know how to do this?

 

[Philly44]

=TRIM([FirstName] & " " & [LastName])

This will cat the 2 together, the " " is just to put a space in between them and using the TRIM() function will removing and leading or trailing white spaces

I hope this helps

 

[LonnieJohnson]

I assume that the two fields are already on the report. I will call them LNAME and FNAME.

1. Add a new text box (unbound).
2. In the control source for this new box put...

= FNAME & " " & LNAME

This will produce "John Smith". If you wish "Smith, John" then put...

= LNAME & ", " & FNAME

3. Set the visible properties for LNAME and FNAME to No.

Good luck, B-) ljprodev@yahoo.com
ProDev, MS Access Applications

http://www.galaxymall.com/software/PRODEV