I am trying to get my qry to show if a employee is a Department Head and has employees assigned to them, then only show those employees assigned with the same Department ID or Department.
2 tables
tblEmployees
tblDepartments
1 qry qryDeptHeadEmployees
1 form frmEmployees
2 tables
tblEmployees
tblDepartments
1 qry qryDeptHeadEmployees
1 form frmEmployees
Last edited: