Combining two fields into one field

  • Thread starter Thread starter Wayne
  • Start date Start date
W

Wayne

Hello,

I am using Access 2002 and have setup a DBase. Currently I find that I am
duplicating information that could easily be done by combine two or more
fields.

I know that it is possible, but I have not been able to find out how.

Example:
Fields Combine
LastName FullName
FirstName

Any ideas or help?

Thanks,
Wayne
 
Concatenate the two fields
[lastname]&", "&[firstname]
of
[firstname&" "&[lastname]

Jim
 
To combine two Text fields (like the Names below):
Assume your table has a FirstName and LastName field
Add a new, blank field called FullName
Create an UpdateQuery, select the FullName field and, on
Click to expand...
the UpdateTo: line, put either:
[FirstName] & " " & [LastName]
or:
[LastName] & ", " & [FirstName]
depending on your preference.
Run the query to update the FullName field
Remove the FirstName and Lastname fields from your
Click to expand...
table, if appropriate.

Check the Help files on UpdateQueries and concatenation.

Hope this helps!

Howard Brody
 
Back
Top