Another Subtotal Formula in Subform Problem (DateDiff Forumula)
I have another sub-form subtotaling issue.
I am entering work that is task based, time based or other.
The below sub-total formula was working until I came to a record that had no time based work at all. The sub-total control for time for this record is blank and as a result, the grand total in the main form is also blank
I tried amending the formula for multiple criteria but I am getting the same results.
Any suggestions?
I have another sub-form subtotaling issue.
I am entering work that is task based, time based or other.
The below sub-total formula was working until I came to a record that had no time based work at all. The sub-total control for time for this record is blank and as a result, the grand total in the main form is also blank
Code:
=Sum(IIf(DateDiff("n",[StartTime],[EndTime])/60<1,1*50,DateDiff("n",[StartTime],[EndTime])/60*50))
I tried amending the formula for multiple criteria but I am getting the same results.
Code:
=Sum(IIf(DateDiff("n",[StartTime],[EndTime])/60=0,0*50,IIf(DateDiff("n",[StartTime],[EndTime])/60<1,1*50,DateDiff("n",[StartTime],[EndTime])/60*50)))
Any suggestions?
Last edited: