combine 2 fields into 1 field

#1

How do I combine data from two fields into one field? Specifically, I
have two fields for LastName and FirstName and a field for FullName.
When new data is entered into LastName and FirstName in a form, I want
it to automatically go to FullName too. I can do this with an update
query, but is there a way to do it automatically without an update
query? Otherwise I'll be constantly doing update queries.

#2

I'm interested in this too, except I want to divide the names...from one
field containing two first names into two fields containing one name each...

Jack

"Andrew" <AndrewEgan (AT) att (DOT) net> wrote

Quote:

How do I combine data from two fields into one field? Specifically, I
have two fields for LastName and FirstName and a field for FullName.
When new data is entered into LastName and FirstName in a form, I want
it to automatically go to FullName too. I can do this with an update
query, but is there a way to do it automatically without an update
query? Otherwise I'll be constantly doing update queries.

#3

Have you tried adding code to the OnChange event of both controls something like
Me!FullName = Me!FirstName & " " & Me!LastName

Jack

AndrewEgan (AT) att (DOT) net (Andrew) wrote in message news:<be34760c.0310211321.5e059fc5 (AT) posting (DOT) google.com>...

Quote:

How do I combine data from two fields into one field? Specifically, I
have two fields for LastName and FirstName and a field for FullName.
When new data is entered into LastName and FirstName in a form, I want
it to automatically go to FullName too. I can do this with an update
query, but is there a way to do it automatically without an update
query? Otherwise I'll be constantly doing update queries.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

combine 2 fields into 1 field

comp.database.ms-access comp.database.ms-access

combine 2 fields into 1 field - 10-21-2003 , 04:21 PM

Re: combine 2 fields into 1 field - 10-21-2003 , 06:57 PM

Re: combine 2 fields into 1 field - 10-22-2003 , 04:59 PM