Thanks Duane. I had it envisioned in my mind but wasn't sure if it would work that way. I have set up a form that will filter by Employee, Shift, Job worked. How do I get that form to pop up when they open the report? I have command buttons on the form that allow the user to set the filter, clear the form and close the form. However, when I select close, it closes both the form and the report. I would also like to have the report set back to the original un-filtered version when it first opens. My report is named JobWorked and my form is named frmFilter.
--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> 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