Combine text from two fields in a new field

[Guest]

I want to to combine LastName and FirstName fields in a new field as follow:
John, Doe.

I used Full Name: [LastName] & [FirstName] with a result: JohnDoe. I need a
comma after last name and a space before the first name. Your prompt
solution will be appriciated!

Thanks

 

[Guest]

Hi I think is prety easy..

use,
[LastName] & ", " & [FirstName]


(e-mail address removed)

 

[John Vinson]

I want to to combine LastName and FirstName fields in a new field as follow:
John, Doe.

I used Full Name: [LastName] & [FirstName] with a result: JohnDoe. I need a
comma after last name and a space before the first name. Your prompt
solution will be appriciated!

Thanks

It is not necessary, wise, or good design to store this derived field
in a Table. Just store the last and first name.

To display the full name, you can either calculate it on demand in a
Query, or in the Control Source property of a form or report textbox.
To do so, use

[FirstName] & " " & [LastName]

to get "John Doe", or (perhaps in a different context),

[LastName] & ", " & [FirstName]

to get "Doe, John". You can use any text string you like within the
quotes as constant "boilerplate".

John W. Vinson[MVP]