copy information from two fields into a new field in same record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I need to take "First Name" and "Last Name" fields and combine the two into a third field, say, "Name" without retyping. Not sure of the exact wording on the Lookup query for the "Name" field, as I keep getting drop-down box of all "First Name" and "Last Name" combinations.

Any help greatly appreciate
Kyle
 
It is possible, just not recommended. Creating this sort field is frowned
upon as it is outside the rules of normalization. In addition, it creates
extra work because if either the FirstName field or the LastName field is
updated, some sort of code or update query will be needed to update the
field which combines them.

You can always concatenate these fields for use in a query as follows:

FullName: FirstName & " " & LastName
or
FullName: LastName & ", " & FirstName


hth,



--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Kyle said:
Hello;

I need to take "First Name" and "Last Name" fields and combine the two
Click to expand...
into a third field, say, "Name" without retyping. Not sure of the exact
wording on the Lookup query for the "Name" field, as I keep getting
drop-down box of all "First Name" and "Last Name" combinations.
 
Hello;

I need to take "First Name" and "Last Name" fields and combine the two into a third field, say, "Name" without retyping. Not sure of the exact wording on the Lookup query for the "Name" field, as I keep getting drop-down box of all "First Name" and "Last Name" combinations.

Any help greatly appreciated
Kyle
Click to expand...

No. You don't want to create such a field. It's redundant.

First off, get rid of all your Lookup field types! Change them to Text
Box. The Lookup Wizard is one of the worst misfeatures Access has ever
implemented; see

http://www.mvps.org/access/lookupfields.htm

for details. Use Forms to do your data entry; table datasheets are
best reserved for debugging.

Then, create a Query based on your table. In a vacant Field cell type

FullName: [First Name] & " " & [Last Name]

If you open this query datasheet you'll see that the fields are
concatenated; this calculated field can be searched, displayed on a
form or report, whatever you want (anything except editing its
content).
 
i've never used a Lookup field type in a table; the first time i tried one,
it made my first query a pain - so i just changed the table and never used
one again. but i didn't realize all the horrors they perpetrate - yowza! now
i have all the good reasons to tell people not to use them, instead of just
"they're a pain".
thanks for the info! :)
 
Back
Top