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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"
 
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.
 
Back
Top