[AccessD] query table

List,

 I have a table that I pull employee records by date range. I have
another table I need to check for employee number to see if the employee
is not there.

Using the simple query linking the tables to employee number on inner
join that checks date range for all records only pulls records that
match. How do I make only the records in the date range table show up if
they are missing in the other table. I am using AK2010.

Steve A. Turner
Controller
Mid-South Engineering Co. Inc
P.O. Box 1399
Hot Springs, AR 71902
E-Mail: sturner at mseco.com and saturner at mseco.com
Phone: (501)321-2276
Fax:     (501)321-4750
Cell:     (501)282-7751