Concatenating Fields.

  • Thread starter Thread starter Gary Nelson
  • Start date Start date
G

Gary Nelson

In Access 2000, I have the below table which is used by our customer service
reps. A form had been created which allowed them to add new contacts. In
doing so, the First name and Last name fields become populated but the
ContactName field does not, and has to be done manually. There are several
other forms which the ContactName populates. My question is...

1) Is there a way that the ContactName field can populate once the
FirstName, LastName fields are populated?

2) As you can see, this table has duplicate data in the FirstName, LastName
and ContactName fields. Is it complex to either utilize the ContactName
field or the FirstName, LastName fields rather than using both?

Also, we are currently using the ContactName field which populates outher
forms....How can I concatenate LastName / FirstName and stop using
ContactName without causing a problem with current forms?

Thanks in advance for your help.
 
Hi,
You can combine them using a query:
Select FirstName & " " & LastName As FullName From ...........
 
Back
Top