Storing a calculated value in an Access table

[Captgeo33]

I have three fields on a form First Name, Last Name and Card holder name. The data entry person enters first name and Last Name and I calculate the thrird field , Cardholder Name, from the first two fields. I would like to store the cardholder Name in the table with the first and last names. How can I do that?

[PhilOfWalton]

It is normally very bad practice to store a calculated value in a table. What happens when you inadvertently change the CardHoldeName? How are you going to automatically alter the FirstName & LastName to reflect the change?

Why do you want to store this field as a Query will show it perfectly well?

Use

CardHolderName = FirstName & " " & LastName
 

or

CardHolderName = LastName & ", " & FirstName 
 

I Also strongly suggest you don't have spaces in both field names and table names as they have to be surrounded with square brackets which I find a pain.

Phil

[Captgeo33]

thank you for the response. I ended up doing exactly what you suggested and it works great.