Combining data from 2 tables where the fields are different

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

Guest

I am trying to combine the data in 2 tables where the fields are different. In one table the fields are "First Name" and "Last Name". In another table the field is "Individual Name" where the first and last names are separated by a comma. I am a casual user to Access. I know how to do basic update and append queries. I've been trying to figure this out for a week and am going nuts! Please help. Nancy
 
Nancy,

Use two queries. First, create a query that joins the FirstName and
LastName into a calculated IndividualName field. Type:

IndividualName : [First Name] & ", " & [LastName] in the field cell of the
query grid.

Then combine _that_ query with the other table.

HTH

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

Nancy said:
I am trying to combine the data in 2 tables where the fields are
Click to expand...
different. In one table the fields are "First Name" and "Last Name". In
another table the field is "Individual Name" where the first and last names
are separated by a comma. I am a casual user to Access. I know how to do
basic update and append queries. I've been trying to figure this out for a
week and am going nuts! Please help. Nancy
 
Back
Top