Bring in the table with the Employee name in it to the query. You should be able to link it togethor with the Employee ID. Then bring in the employee name field. That would be the ideal way, alternatively you could DLookup

Thanks for the help.  You got me on the right track.  I successfully set up a combined LEFT and RIGHT JOIN.  I have a lot to learn.  Seems like I always need to be two classes ahead of where I am.