Writing a query to find unassigned people

[jtice01]

I have a problem, whereby, I need to create a query to find people who are unassigned for a particular month.
The tables are [Personnel], [_Months], [WorkAllotments],[projects]

[WorkAllotments] has the fields:
{Person}{project}{-Month}{Allotment}

The way it works is that a manager enters a percentage that a particular work has spent on a particular project during the course of the month. However, if the manager neglected to remember a person, no entries would apply for that person for that month. It would seem in that case that Is Null or IsNull("") would not work, because there wouldnt even be a "0" percentage for that person.

It would seem like I would need to relate the Personnel table to the months and WorkAllotments table and cross reference that somehow with an Is Not Null statement. So, the idea being that any person that had an entry would be excluded from showing up in this query.

I just dont know what the actual architecture would be... any ideas?

 

[JHB]

You can do that using an unmatched query.
First create a query which find all people assigned to the project.
Then a query which find all people which has worked on the project in a particular month.
Use the query wizard to set up the unmatched query.
Read the explanation in the wizard - then it is very easy.