Adding two tables together

D

dwaynesworld

I have two tables which list employees who have completed mandatory testing
for each subject. What I would like to do is combine the data into 1 table
listing the employee name (key), test one (Complete,In Progress, Not
Accessed), and test two (True/False). I have tried a make table query but am
running into problems with duplicate data. The max number of employees are
477 but I am either returning 27 or 239685 records. What am I missing?

Thanks in advance...
 
P

Pendragon

If you want to add table 2 to table 1, just do an append query. You get
duplicate data problems because you have set your Key on the name, most
likely. Do the tables have history of completions? What about if you have
two individuals named John Smith?
 
J

John Vinson

I have two tables which list employees who have completed mandatory testing
for each subject. What I would like to do is combine the data into 1 table
listing the employee name (key), test one (Complete,In Progress, Not
Accessed), and test two (True/False). I have tried a make table query but am
running into problems with duplicate data. The max number of employees are
477 but I am either returning 27 or 239685 records. What am I missing?

Thanks in advance...
Click to expand...

What are the structures of the two tables? If you wish to see data
from both tables, I strongly suspect that you can use a Query joining
them - it is emphatically NOT necessary to create a new table!

How are the two tables related? What fields are in which? What is the
Primary Key of each table?

John W. Vinson[MVP]
 
Top