I have a query with [tblEmployees] and [qryJobPositionAssigned]. They are joined by EmployeesID. I want to show everyone in [tblEmployees] that are NOT in [qryJobPositionAssigned]. I'm drawing a blank today.
I have a query with [tblEmployees] and [qryJobPositionAssigned]. They are joined by EmployeesID. I want to show everyone in [tblEmployees] that are NOT in [qryJobPositionAssigned]. I'm drawing a blank today.
did you investigate unmatched query wizard? (ribbon > create >query wizard)
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
No. never heard of it.
I tried it, but it didn't work. I found a field that wasn't showing up and used the criteria isnull. Worked. Thanks