query to locate which record was not added

[buddyr via AccessMonster.com]

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

 

[John W. Vinson]

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>

 

[buddyr via AccessMonster.com]

thanks for the help

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>