How do I take 3 fields and put the data into one field

J

johnp51flyboy

I need to take 3 fields Name, First, and middle to one field "Name". For
examplre
Name=Smith
First=John
Middle=C

The Name field should look like this "Smith John, C"
 
R

Rick B

First, "Name" is a reserved word and should not be used as a field name.
Change it to LastName. If you want to do this in a query, add a new column
to your query and put the following...

CombName: [LastName] & ", " [FirstName] & (" "+[Middle])

To do it in a report or form, add an unbound text box and put the following
in it...

=[LastName] & ", " [FirstName] & (" "+[Middle])

(of course if the report or form is based on your query, then you will be
able to simply pull in the new "CombNmae" field we built in the query.
 
Top