O
Opal
I am looking for the best way to create a report for attendance.
Attendance is calculated by deducting the total number of absent
employees (this is determined by user input) from the total
number of employees on the roll divided by the authorized
number of employees on the roll.
The authorized number does not equal the total number of
employees. The authorized number is input by management
into a table. This same table has a manual input for the
total number of employees on the roll. I would like to automate
this second function with a DCount from the employee table
but am having difficulty as to the best way to do this.
Should I do it in the query bound to the report or should
I do it in the report or should I do it in the report using
VBA when the report is loaded.
Can anyone offer some advice?
Attendance is calculated by deducting the total number of absent
employees (this is determined by user input) from the total
number of employees on the roll divided by the authorized
number of employees on the roll.
The authorized number does not equal the total number of
employees. The authorized number is input by management
into a table. This same table has a manual input for the
total number of employees on the roll. I would like to automate
this second function with a DCount from the employee table
but am having difficulty as to the best way to do this.
Should I do it in the query bound to the report or should
I do it in the report or should I do it in the report using
VBA when the report is loaded.
Can anyone offer some advice?