microsoft.access.courses - Combined multiple queries

Hello. This is a complicated one.

I've built a database (Access 2003) to capture customer information for a new product. The database has integrated a so-called process management function. In essence, at each customer level (form), and for each task, there are

1. a 'due date' (pre-set date that a task has to be done)
2. a 'competion date' (when the task has been done, customer advisor inputs the date in the field)

All the above is working perfectly fine at the customer level.

However, problem arises in the reporting level...



I need a combined view of the process management for all customers. I have tried to do this by creating an individual select query for each task. Note: there are 20 tasks in total. So if the task has not been done before the due date, it will be considered as 'overdue'.

The query criteria is as follows:

if due date < today's date
and
if completion date is null
then
the 'due date' will appear

I have created 20 seperate queries for all tasks, and they work completely fine independently.

When I tried to combine them into one big query, overdue tasks DO appear at the customer level (row), which is great. However, tasks that are NOT overdue also appear at the customer level even though not one task is overdue.



My question is: Is there any way to fiddle with the structure of my query/queries to prevent empty rows from appearing in the combined query? Or is there any way that I can overcome this problem by restructuring my queries?


Heaps of thanks!

Amanda