filtering subreport

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

I don't know if this can be done.

My main report is based on timesheets that are overdue.
therefore, if any of the controls for their times have a
null value, the name of the employee will show up on the
report.
on the form that the timesheets are entered, the
employees name is pulled from a separate table where it's
id is linked to an employee field in the timesheet table.
so, only the employees that have had something entered in
any of the controls for their times will show up if some
of them are missing.
In response to this, I created another report that has
all the employee names on it, and placed it as a
supreport.
the report is opened through a form that filters it for
the Month and Year for whatever timespan is required.

I'm having trouble trying to get the information to link
up, so that I have a complete list of employees that are
missing.

In other words, I want a complete list of EVERYONE that
is missing their timesheets for any given month, whether
they have handed in a portion of them, or none.

Can this be done? and how?
 
You haven't described the underlying data structure quite enough for me to
envision what you are starting with. The following is pure speculation,
pending more details...

If your timesheet table does not contain "blank" "placeholder" rows for the
employees (and I'd recommend AGAINST doing that), you could use the
"unmatched query" wizard against your timesheet table. You'd be looking for
Employees not in Timesheet (for your criteria). This would get you the "no
timesheet" group.

Trying to find Employees with Timesheets, but "incomplete", will require
more work, as you will have to define any/all possible valid combinations of
incompleteness in the "time" fields. It sounds a little like the structure
of the Timesheet table looks like a spreadsheet, in which case your work to
define incompleteness is considerably harder.
 
Back
Top