Subquery for missing items asking for date multiple times

[brischoon]

I have a report based on a query that shows all task items completed for the
day. The query requests a date to retrieve items for that particular day.
At the report footer, I placed a second query which retrieves the tasks from
a separate table that were not performed (or entered into the table) for that
day. I have it search by date as well.

However, when I combine the query on the report footer and run the report,
it asks me for the date multiple times. How can I have it ask for the date
only once? SQL statement for the second query (to return missing task items)
is listed below:

SELECT Tasks.[Task Description]
FROM Tasks
WHERE (((Tasks.[Task Description]) Not In (Select [Scorecard Data].[Task]
From [Scorecard Data]
WHERE [Scorecard Data].[Date] = [Daily Scorecard Data].[Date])));


- Tasks table is the reference table with the list of all tasks
- Scorecard Data is the data table with values being input daily
- Daily Scorecard Data is the primary query that runs the report