Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / General 2 / June 2007

Tip: Looking for answers? Try searching our database.

Merging Fields in an Access Database

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jimbo78 - 20 Jun 2007 17:43 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.