create a query to find names not entered

[tomClark]

Hello,
will try to explain.
i have 4 employees.
jim, jack, joe, and john.
every week a report is created that needs to have one record from each of them.
But they are not responsible and may forget to submit data.
first week
Table1
name endDate
Jim 2/6/10
Joe 2/6/10
John 2/6/10
* Jack forgot to turn in his report*
Is there anyway to find this out with a query? sql statement?

you may say -you can see easy with 4 records - who is missing-

but with 50 names and if it was 49 entries it will take longer to find name not there.
I am able to count the records and display no of records on report -


but I am being asked to provide names of people not on report

Does anybody know if this can be done in a query?
also any helpfull advice to solve this will be helpfull - using my example to go from
thank you

[pbaldy]

Depending on your structure, one way would be a query that returns those that have turned in their report, and then an unmatched query of that against the table containing all employees.

[maximus]

The problem that you have mentioned cane be solved in more than one ways and to suggest the most effective solution I need a details of you table structure to determine how you actually store data. Then only a solution is possible.

[tomClark]

thanks - i used pbaldy advice

[pbaldy]

Happy to help.