4 Tables having trouble

  • Thread starter Thread starter macamarr
  • Start date Start date
M

macamarr

Hello, thank you in advance for your help. I have four tables, Master
Employee, Cell Phone, Position and email. These were all imported from
different spreadsheets. The issue I am having is; The Master Employee table
has all the names and the other tables don't. Some names in all tables some
not. I want to query and retrieve information available on all employees in
the master table with one row per employee. I’ve tried to append and the info
goes to the table but it creates new rows. Where am I going wrong?
 
Hello, thank you in advance for your help. I have four tables, Master
Employee, Cell Phone, Position and email. These were all imported from
different spreadsheets. The issue I am having is; The Master Employee table
has all the names and the other tables don't. Some names in all tables some
not. I want to query and retrieve information available on all employees in
the master table with one row per employee. I’ve tried to append and the info
goes to the table but it creates new rows. Where am I going wrong?
Click to expand...

Is there any information in the other three tables which would identify to
WHICH employee the record refers? If you have a cell phone record 333-333-3333
with nothing else in it how could Access (or you or me or anyone!!) tell?

More info please!

An Append query would certainly NOT work - a cell phone is not an employee, so
appending a cell phone record to the employee table would not be the right way
to go. Perhaps you could post some examples (obscured for privacy) of the
actual contents of your spreadsheets.
 
Hi,

You want to do a select query, joining all the tables by name. Once you
have created the joins, you want to click on the line, and change the join to
select all from the master employee table, and only those rows from the other
tables where the names match.
 
Back
Top