combining fields

G

Glenn

I have a database with let's say 3 fields.

Field 1 = LastName
Field 2 = FirstName

I'd like Field 3 to be automatically created from the data in fields 1 & 2
as follows: LastName, FirstName

Is this possible?

Thanks.
 
R

Rick B

No. You don't store calculated (or in this case concantenated) fields in a
database. You can create the combined name in your query, form, or report.
Storing the individual names and the combined name would be redundant.

You are correct in storing the names separateley as you have done. Now, you
have the option to print or display only the first name, the first and last,
the last and first, etc.

Rick B
 
F

fredg

I have a database with let's say 3 fields.

Field 1 = LastName
Field 2 = FirstName

I'd like Field 3 to be automatically created from the data in fields 1 & 2
as follows: LastName, FirstName

Is this possible?

Thanks.
Click to expand...

It's possible, but only if you are willing to break one of Access
rules.... Store only the minimum data necessary.
It's not necessary to store the combined name. It wastes memory, disk
space, and is susceptible to being incorrect if one of the other names
has been changed.

It is very easy to combine the names when needed.
Where ever you need to show LastName, FirstName combine them, in a
query, form or report:
=[LastName] & ", " & [FirstName]
 
Top