Calculated field

[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?

 

[NetworkTrade]

advice? use query.

Reports has a nice convenient feature to do some summary math for a column
that is in the report...ie. sum, avg, max, min, etc.....and one uses that all
the time because is very convenient....but it really is intended to be
summarized data of the column in the report....

you have a multistep with a total then a divide by....I would get this
working in a query before setting up the report....I myself would not rely on
the report or vb in the report to do this....