summing in report

  • Thread starter Thread starter stephendeloach via AccessMonster.com
  • Start date Start date
S

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?
 
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?
Click to expand...

Does this work properly?

=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
([TotalHours]-14640) * 51)
 
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?
Click to expand...

Does this work properly?

=IIf([TotalHours]<=14640,[TotalHours]*45,(14640 * 45) +
([TotalHours]-14640) * 51)
Click to expand...
 
Back
Top