I have a form which the user selects the employee and then selects the job worked, enters hours scheduled, hours worked, hours refused etc. I have created a report that will pull the employee, shift, job worked and work date. As this will become quite large I would like to do one of the following:
1) create a command button on the report that when clicked would filter the report by employee and then a second button that would filter by job worked depending on what the user was looking for. this would give the user the choice of the full report or a filterd version based on either employee or job worked.
2) another option would be to provide only the most recent dates worked for each employee (last 10 days)thus creating only a portion of the report at all times.
The report is grouped by Shift with each employee, job worked and date worked falling under each Shift group.
Any advice would be appreciated.
Thanks in advance
Angie
Tidak ada komentar:
Posting Komentar