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
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