Question on including records with a null value

[BLT1976]

We have an existing database that pulls a number of its tables from links to Excel worksheets that are updated each night. In one query, I have a field that shows and Employee ID and that links to a table with ID #s and the employee's name.

The problem is that some cases we have are not "owned" and therefore not assigned an employee ID in this field. Therefore, teh query does not include the record because that particular field is blank.

What I need is for the query to pull ALL records and include the employee's name who owns it when available and leave blank when there is not one assigned.

I know I need enter something into the Criteria of this field, but I am not sure what to enter.

Thanks.

 

[dcx693]

I think you need to change your join type from inner- to left- or right-join. That way, you'll get all records whether or not there is a match on the linked table.

 

[BLT1976]

Thanks!

It worked! I can't believe I forgot that structural design element. Thanks for the reminder.