Combining two fields into one field

[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

 

[Jim/Chris]

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

Jim

 

[Howard Brody]

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

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

table, if appropriate.

Check the Help files on UpdateQueries and concatenation.

Hope this helps!

Howard Brody