Good night,
I have been struggling to show a subtotal in the footer of an invoicing subform.
The subform has the following text boxes
[StartTime]
[EndTime]
The standard rate is $50.00 for the first hour or part thereof; $50.00 per hour thereafter.
I have calculated the time elapsed using the DateDiff formula in text box named [TTLTime]. To calculate the cost per record I used the following formula in text box [SubTotalHrs]
=(([TTLTime]-1)*50)+50
I am now trying to show the subtotal in the subform footer and every formula I try is returning #Error - Sum((([TTLTime]-1)*50)+50); sum([SubTotalHrs]); Sum(Nz([SubTotalHrs],0))
Nothing is working and I don't know why.
Been searching this forum and tried a couple suggestions but still nothing working.
Would appreciate your suggestions.
Thanks
I have been struggling to show a subtotal in the footer of an invoicing subform.
The subform has the following text boxes
[StartTime]
[EndTime]
The standard rate is $50.00 for the first hour or part thereof; $50.00 per hour thereafter.
I have calculated the time elapsed using the DateDiff formula in text box named [TTLTime]. To calculate the cost per record I used the following formula in text box [SubTotalHrs]
=(([TTLTime]-1)*50)+50
I am now trying to show the subtotal in the subform footer and every formula I try is returning #Error - Sum((([TTLTime]-1)*50)+50); sum([SubTotalHrs]); Sum(Nz([SubTotalHrs],0))
Nothing is working and I don't know why.
Been searching this forum and tried a couple suggestions but still nothing working.
Would appreciate your suggestions.
Thanks