If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
4 Tables having trouble
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? |
#2
|
|||
|
|||
4 Tables having trouble
On Wed, 29 Jul 2009 17:02:04 -0700, macamarr
wrote: 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? 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. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
4 Tables having trouble
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. "macamarr" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|