I have created a form that takes all employees and groups them by department. The form is based on a query includes 3 tables. I look and the employee is in the employee table, but when I run the query, the employee is not there. Any ideas why? It is a simple select query.