If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
filtering subreport
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? |
#2
|
|||
|
|||
filtering subreport
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. -- More info, please ... Jeff Boyce Access MVP |
Thread Tools | |
Display Modes | |
|
|