Access Query build

[zarfx4]

Hello...I think I might be over complicating this...



Here is what I have...

Table1 called data with a bunch of columns...whats important is as follows

Date Ticket# OwnerID Shift

Table2 called Employee with the following:

Employee EID Shift

What I need to do, is add the value in the the Shift column from my Employee table to the data table. EID and OwnerID are related....heres the issue...in the data table...ther are Employee IDs (EID) that do not exsist, nor will they ever, in the Employee table....

So if i create a query, make a relation ship, im not getting 100% of my results. I need to add the Shift to the values I can, and leave the ones blank that do not have a result.

Any suggestions?

[pbaldy]

Try changing the join. With the query in design view, right click on the line between the two tables and edit the join. Choose the appropriate "Select all records from...".

[zarfx4]

Tried that already...one join results in NOTHING...the other join results in only matched records where the EID is in both tables....

This is why I said that I need ALL results from the data table and only the info from the employee table where it matches...

[pbaldy]

The join should look like this in SQL view:

...FROM DataTable LEFT JOIN EmployeeTable ON...

Can you post the db?