Report Totals

[evr72]

Hello,

I have a report that calculates the employee efficiency in total

=Sum([STDHrs])/Sum([Lab Hrs])

This works well. The issue is that if an employee works indirect hours then "Lab Hrs" have a value and "STDHrs" do not, this makes the efficiency lower.

Is there a way to calculate the "STDHrs" that have a value but still show the ones that do not?

 

[dhookom]

This is most likely possible. Please provide about 10 records and the desired end result of the calculation so we can better understand the logic.

Duane
Hook'D on Access
MS Access MVP