Is there a way to merge two fields in an Access database? ie: merge the first
and last name fields so the first and last name appear together.
RBear3 - 20 Jun 2007 17:47 GMT
Yes. Where would you like to do so? You should leave them separate in your
table.
In a query, create a new column and put something like this in it:
FullName: [FirstName] & " " & [LastName]
In a report or form, create an unbound text box and put the following in it:
=[FirstName] & " " & [LastName]

Signature
Hope that helps!
RBear3
.
> Is there a way to merge two fields in an Access database? ie: merge the
> first
> and last name fields so the first and last name appear together.
BruceM - 20 Jun 2007 17:50 GMT
In a text box, set the Control Source to:
=FirstName & " " & LastName
Another way, using the same expression, is to base a query on the table in
question. In query design view, at the top of an empty column:
FullName: FirstName & " " & LastName
Use your actual field names. In the query, FullName can be whatever you
like.
Combining fields like this is called concatenation. It is a type of
calculation, so the resulting value is obtained as needed. The concatenated
value is not stored.
> Is there a way to merge two fields in an Access database? ie: merge the
> first
> and last name fields so the first and last name appear together.
Carol Grismore - 20 Jun 2007 18:03 GMT
It's easy to do with a query -- just create a query using the table that
contains the fields you want to merge. Use the Simple Query Wizard if you're
new to Access. Select all the data.
Change to design view (select the triangle button from the menu). Create a
new column that merges the fields you want in one column. Type:
Name: first & " " & last
(or whatever the field names are) into the top row of any blank query column.
Change back to datasheet view. There's your merged column.
You can use this query as if it were a table.
--
Carol
> Is there a way to merge two fields in an Access database? ie: merge the first
> and last name fields so the first and last name appear together.
BruceM - 20 Jun 2007 18:16 GMT
However, you should not use First, Last, or Name as field names. First and
Last are reserved words in Jet; Name is a reserved word in Access. Here are
some links with more information about this issue:
http://www.allenbrowne.com/AppIssueBadWord.html
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#ReservedWords
> It's easy to do with a query -- just create a query using the table that
> contains the fields you want to merge. Use the Simple Query Wizard if
[quoted text clipped - 12 lines]
>> first
>> and last name fields so the first and last name appear together.