G
Guest
Employees who work on a Client File will enter the payroll information on a
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.
At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?
To access a REPORT that displays the identical information I need,
I set the criteria to…..
And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.
How can I open the newly designed FORM? Any thoughts?
R Marko
continuous form linked to the Client Record. To edit employee information,
the employee record is accessed through the Client Record.
At the end of a pay period, I would like to have access to a list of all
employees who have worked during that pay period so I have designed a form to
display a list of part time employees, sorted by date worked, showing the
hours they worked. When I open the form, all of the records in the table are
displayed. I would like to display only those employees who have worked
within a particular pay period. How can I make that happen?
To access a REPORT that displays the identical information I need,
I set the criteria to…..
=[forms]![msgReportRange]![Between] And <=[forms]![msgReportRange]![And]
And then enter the begindate and enddate of the payroll period. But I
cannot edit the information in a report.
How can I open the newly designed FORM? Any thoughts?
R Marko