Identifying Empty Records

[ChronicFear]

Hello,

I have a database where project managers enter information about the status of their projects quarterly. This is something they will need to do each and every quarter. I am trying to create a query to determine who has not entered anything for their product in a given quarter so that I can yell at them.

Right now I have a query where I compare my master list of projects against the table that holds all the individual project updates (I'm not sure if I call this an inner or outter join, but the query returns everything from the master list and only those records in the other table that match. I then filter with Is Null on the project field in the table with individual projects and VOILA! I have my list of projects that need updating.

However...this search only works in a general capacity, meaning that if nothing at all is entered about a certain product, it will show up on the list. What it won't do is say that although information about Project A was entered in Q1, it was not entered in Q2. Normally I would filter by quater, but since there isn't any data, there's nothing to filter on.

Does anyone have any ideas?

Thanks,
CF

 

[pbaldy]

My first thought is to create a query that pulls records from the second table for the desired quarter, and then use that instead of the second table in your query.

 

[ChronicFear]

You, Sir, are a genius!

Now a follow-up, if I may: The form that I have for people to build their reports uses a multi-select list box for the quarters. How can I get multiple values from that into the query?

Thanks.

 

[ChronicFear]

***BUMP***


So far I have the two queries working great, but I need a way to control for which quarters are selected from a multi-listbox.

It's easy enough to set a reference to the form that contains the listbox, but that only works if one choice is selected. If two are selected, how can I add that to the query so it returns Choice A OR Choice B?

Thanks,
CF