I have never placed "a command button on the report". I typically create an unbound form for the user to select filtering criteria such as date range, job worked, shift, etc. Then I have some method of selecting and opening a report. The report uses the criteria to filter the report.
Duane Hookom
MS Access MVP
--- In MS_Access_Professionals@yahoogroups.com, "Angie" <paankadu@...> wrote:
>
> 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