Report calculations are wrong on some records but not others

[Kevin]

On some records, the calculation is correct but on others it is wrong, why?

the calculation is as follows (the source of each part of the calculation is
below it):

txtActualWage =[txtLaborRevenue]\[txtTotalHours]

txtLaborRevenue =rptLaborSubReport!TotalLaborCost
TotalLaborCost =Sum((DateDiff("n",[StartTime],[EndTime])/60)*[Pay])

txtTotalHours
=IIf(IsError(rptLaborSubReport!txtTotalHours),0,rp tLaborSubReport!txtTotalHours)
txtTotalHours =Sum(DateDiff("n",[StartTime],[EndTime])/60)

So in example one...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$25.00 $912.50 36.50

in example two...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$23.00 $187.50 7.50

why is this wrong? are my calculation to complex? using too many calculated
controls for the end result?

Any guidance greatly appreciated.

[Last Boy Scout]

Kevin wrote:

On some records, the calculation is correct but on others it is wrong, why?

the calculation is as follows (the source of each part of the calculation is
below it):

txtActualWage =[txtLaborRevenue]\[txtTotalHours]

txtLaborRevenue =rptLaborSubReport!TotalLaborCost
TotalLaborCost =Sum((DateDiff("n",[StartTime],[EndTime])/60)*[Pay])

txtTotalHours
=IIf(IsError(rptLaborSubReport!txtTotalHours),0,rp tLaborSubReport!txtTotalHours)
txtTotalHours =Sum(DateDiff("n",[StartTime],[EndTime])/60)

So in example one...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$25.00 $912.50 36.50

in example two...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$23.00 $187.50 7.50

why is this wrong? are my calculation to complex? using too many calculated
controls for the end result?

Any guidance greatly appreciated.

What if there are no hours, i.e. Salary Employee?

[Scott]

Are you pulling in your labor revenue and your total hours separately so
that you can be sure the are pulling in correctly?

"Kevin" <no**@email.comwrote in message
news:xc*********************@fe07.news.easynews.co m...

On some records, the calculation is correct but on others it is wrong,
why?

the calculation is as follows (the source of each part of the calculation
is below it):

txtActualWage =[txtLaborRevenue]\[txtTotalHours]

txtLaborRevenue =rptLaborSubReport!TotalLaborCost
TotalLaborCost =Sum((DateDiff("n",[StartTime],[EndTime])/60)*[Pay])

txtTotalHours
=IIf(IsError(rptLaborSubReport!txtTotalHours),0,rp tLaborSubReport!txtTotalHours)
txtTotalHours =Sum(DateDiff("n",[StartTime],[EndTime])/60)

So in example one...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$25.00 $912.50 36.50

in example two...
txtActualWage =[txtLaborRevenue]\[txtTotalHours]
$23.00 $187.50 7.50

why is this wrong? are my calculation to complex? using too many
calculated controls for the end result?

Any guidance greatly appreciated.

[Kevin]

Are you pulling in your labor revenue and your total hours separately so

that you can be sure the are pulling in correctly?

yes...

>txtActualWage =[txtLaborRevenue]\[txtTotalHours]

txtLaborRevenue pulls from a calc control on rptLaborSubreport,
TotalLaborCost. This calculated control, TotalLaborCost uses the
calculation - =Sum((DateDiff("n",[StartTime],[EndTime])/60)*[Pay])

and txtTotalHours is from the same subreport, a control named txtTotalHours
which uses the following calculation -
=IIf(IsError(rptLaborSubReport!txtTotalHours),0,rp tLaborSubReport!txtTotalHours)

I toyed with the idea of a rounding discrpency but that doesnt seem to fit.
The data type for the various fields are appropriate; StartTime EndTime are
both Date/Time fields, Pay is a currency field. As for the formatting of the
calculated controls; txtTotalHours is Fixed with 2 decimals, txtLaborRevenue
is Currency and txtActualWage is currency.

[Kevin]

I'm not sure I see where this is relevent to the question at hand?

"Last Boy Scout" <Ba*****@whitehouse.govwrote in message
news:_Q************@newsfe03.lga...

What if there are no hours, i.e. Salary Employee?

[Scott]

So if you have your two fields pulling in correctly, the revenue field and
the hours field, have you tried running your calculation from these two
fields and not pulling the information from the subreport?

"Kevin" <no**@email.comwrote in message
news:da*********************@fe08.news.easynews.co m...

>Are you pulling in your labor revenue and your total hours separately so
that you can be sure the are pulling in correctly?

yes...

>>txtActualWage =[txtLaborRevenue]\[txtTotalHours]

txtLaborRevenue pulls from a calc control on rptLaborSubreport,
TotalLaborCost. This calculated control, TotalLaborCost uses the
calculation - =Sum((DateDiff("n",[StartTime],[EndTime])/60)*[Pay])

and txtTotalHours is from the same subreport, a control named
txtTotalHours which uses the following calculation -
=IIf(IsError(rptLaborSubReport!txtTotalHours),0,rp tLaborSubReport!txtTotalHours)

I toyed with the idea of a rounding discrpency but that doesnt seem to
fit. The data type for the various fields are appropriate; StartTime
EndTime are both Date/Time fields, Pay is a currency field. As for the
formatting of the calculated controls; txtTotalHours is Fixed with 2
decimals, txtLaborRevenue is Currency and txtActualWage is currency.

[Kevin]

Rather than using the calculation =[txtLaborRevenue]\[txtTotalHours], I
substitued the formulas from the calculated fields on my report
(txtLaborRevenue & txtTotalHours) and the calculations are correct. What
would account for the discrepency? Could this be a rounding issue?

"Scott" <sc**********@ns.sympatico.cawrote in message
news:2y********************@ursa-nb00s0.nbnet.nb.ca...

So if you have your two fields pulling in correctly, the revenue field and
the hours field, have you tried running your calculation from these two
fields and not pulling the information from the subreport?