Find missing or duplicate records by date

[Bob Groger]

Hello again.

I have a table "Timesheets" where a timesheet is entered for an employee
each day, including days not worked. A pay period is 14 days. I am trying to
query by employee ID where # of timesheets entered <>14 between beginning
date and ending date. It sounds simple but I am stumbling here. Should I be
using Count() to do this?

Thanks!

Bob Groger

 

[Tom Ellison]

Dear Bob:

To be able to help you, please post details of the table you have, and the
query you have written.

Tom Ellison