Pulling Data From Different Tables For 1 Employee - Join problem

[Happy2]

Hi all,

Thank you so much for helping me out with my previous questions.
Now I have another Problem that needs to be resolved Asap.

I have 3 tables: Employee, Payroll, and 401K.
Employee is the main table and EmployeeID is in both
Payroll and 401K tables. Because the user doesn't always
create a record for a certain employee in the payroll first.
For this reason, not all Employees are in both 2 tables.
I am supposed to pull out all info from the 3 tables.
I have full outer join between the Payroll and the 401K tables
and how can I link with the Employee table to get the Employee NAME.
I can't think of a type of JOIN to pull out employee name.
Please help me out.

Thanks a lot for your help.

 

[zambezibill]

You will use an outer join.

Right click on the join line between tables/queries and you should get a form offering three choices for join types. What you want is the one that selects all records from one table/query (Employee) and matching records from a second joined table/query (401K, Payroll).

The resultant recordset will give you all employees and any matching payroll/401K records.

Cheers, Bill

 

[Happy2]

Thank you so much for your help, Bill.

 

[Happy2]

Thank you so much for your help, Bill.