I am a little confused about this.

What does Nz with the date do?

I do not see where the tasks from the query (the master
list of tasks) are being compared to the list of tasks
that the employee has already completed from the table.

The master list of tasks (the query: query1) may contain
100 tasks to be completed for the year.

The table (table1) records the employee, the tasks he
completed, and the date he completed it.

The new query, I hope, will compare that table to the
query to determine which tasks the employee still needs
to complete.

-----Original Message-----
SELECT employee, task
FROM tblMyTable
WHERE Nz([taskcompleteddate], 99999) Date()
ORDER BY employee