Concatenating fields

[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.

 

[Fredg]

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.

Gary,
All you need is just the FirstName and LastName fields.
Unless the ContactName can be some one different, if you must show the
combined name, you just use the following expression in an unbound
control:
=[FirstName] & " " & [LastName]

No need to save that ContactName.