summing in report

[stephendeloach via AccessMonster.com]

I have a report that has a running sum of Total Hours and Total Money. The
problem i have run into is, 14640 hours need to be multiplied by $45 and the
rest of the hours from now on need to by multiplied by $51... How can I go
about doing this without re-creating my report?

 

[fredg]

I have a report that has a running sum of Total Hours and Total Money. The
problem i have run into is, 14640 hours need to be multiplied by $45 and the
rest of the hours from now on need to by multiplied by $51... How can I go
about doing this without re-creating my report?

Does this work properly?

=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
([TotalHours]-14640) * 51)

 

[stephendeloach via AccessMonster.com]

Actually, let me rephrase that... I have a list oh Hours and a list of Cost...
In the Report footer, I have Total Hours =SUM([Wildcat]) <-- Wildcat is
Hours and Total Cost = (this is where you said to put the expression).
Now how would I type the expression... =IIf([??????])....
Dont know if this makes sense. But thanks for your time..

I have a report that has a running sum of Total Hours and Total Money. The
problem i have run into is, 14640 hours need to be multiplied by $45 and the
rest of the hours from now on need to by multiplied by $51... How can I go
about doing this without re-creating my report?

Does this work properly?

=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
([TotalHours]-14640) * 51)