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

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyT...764559036.html


wrote in message
...
I have a query of a table that lists all tasks for this
year.

I have another table that records each employee, the task
completed, and the date it was completed on.

I desire to create a query that will return the employee
and the tasks that he has not completed.

Can someone assist me with this? I truly appreciate the
help.