=Sum([Total])

[Fitz]

I have daily hours on different equipment, I seperate them by Equipment name. I sum the hours of each =Sum([Totall Hours]). Depending on the amount of hours used I want to apply the following formula:
=Sum(IIf([Total Hours]<=26.4,[Total Hours]*[Daily]/8,IIf([Total Hours]<=40,[Daily]*4,IIf([Total Hours]<=119,[Total Hours]*[Weekly]/40,IIf([Total Hours]<=176,[Monthly],IIf([Total Hours]>=177,[Total Hours]*[Monthly]/176))))))

This formula works for daily, but not for =Sum([Total Hours])

No Luck

 

[Parra]

I think you'll have to create a query off the query you already have to sum the "Total Hours".

 

[Fitz]

Parra:
Thanks for your reply. I'am Not sure how I would apply Query Query.
This is what I have.

Date TotallHours Daily Weekly Monthly TotalCost
3/6/03 8 50 150 450
3/7/03 8 50 150 450
3/8/03 8 50 150 450
3/9/03 8 50 150 450
3/9/03 8 50 150 450
---------------------------------------------------------------
56 ??????
---------------------------------------------------------------
When the =Sum([TotalHours]) meet a certain amount the IIf formula will do it's thing.

Thanks

Fitz