query to locate which record was not added

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 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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201002/1

On Wed, 24 Feb 2010 02:43:57 GMT, "buddyr via AccessMonster.com" u57883@uwe
wrote:

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 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

I presume you have a fifty-row table of Employees... right?

If so, create a Query selecting the records for the desired date range from
Table1. Then use the Unmatched Query Wizard to create a query joining the
Employees table to this query.

Of course Jack is having the time of his life on a vacation to a ski chalet in
Switzerland, so it's ok... g
--

John W. Vinson [MVP]

thanks for the help

John W. Vinson wrote:
Hello,
will try to explain.
[quoted text clipped - 23 lines]
go from
thank you

I presume you have a fifty-row table of Employees... right?

If so, create a Query selecting the records for the desired date range from
Table1. Then use the Unmatched Query Wizard to create a query joining the
Employees table to this query.

Of course Jack is having the time of his life on a vacation to a ski chalet in
Switzerland, so it's ok... g

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201002/1