By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,584 Members | 3,458 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,584 IT Pros & Developers. It's quick & easy.

access field merging

P: n/a
i am building a movie database in microsoft access. I have a field
for actors last name and a field for actors first name as well as field
for actors fullname. I want the full name field to automatically
populate with the information from the first name and last name fields.
Can anybody help me with this please

Don

Jan 9 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Don:

If you have FirstName and LastName fields, you don't need a FullName field.
Not only do you not need it, you don't want it. Duplicating information will
only complicate things and require that you synchronize things. What happens
when someone adds a Madien-Married name to the FullName field, like this

Mary Huffnagle ... becomes Mary Huffnagle Hickenlooper

So, does the first name become Mary Huffnagle and the last Hickenlooper
or does the first stay Mary and the last become Huffnagle Hickenlooper?
Now, someone edits the FullName column like this

Mary Huffnagle ... becomes Mary Jo Huffnagle.

Ahhh. It's obvious that Jo is part of the first name, so we would put it in
the FirstName field and leave the LastName alone.

So, leave the first and last names atomic and when you need to display a
Full Name, then concatonate them in a query.

SELECT FirstName, LastName, FirstName & LastName As FullName FROM YourTable

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast/

<dp*****@gmail.com> wrote ...
i am building a movie database in microsoft access. I have a field
for actors last name and a field for actors first name as well as field
for actors fullname. I want the full name field to automatically
populate with the information from the first name and last name fields.
Can anybody help me with this please

Don

Jan 9 '06 #2

P: n/a
You dont need the Full Name field as part of your table, but you can
place the Field as an Unbound TextField on your form and set its
Control Source as;

=[FirstName]&" "&[LastName]

GAVO.

Jan 9 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.