Can anyone tell me why I am "missing an operator" in this expression?
Bonus Amt: If([SumOfQuantity]>75 and <101) Then
=([SumOfQuantity]*5)
ElseIf ([SumOfQuantity])>100 Then
=([SumOfQuantity])*10)
End If
I have a report with 4 subforms (one for each category). The category totals are in the subform, category footer. I need to add all these totals together for a grand total, but nothing I try works.
I have a report with 4 subforms for 4 categories. I have category totals in the subform footer. My problem is that I can't get a grand total for all the category totals. Any suggestions would be greatly appreciated as my sanity is at stake. I'm thinking that maybe I'm trying to to the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.