Hey guys,
So close to fixing my report, but alas, Access is refusing to accept my sum function statement that I am using as a control source.
I'm trying to total all the PAB_AMOUNT figures except ones occuring on WAGE TYPE 9348 and 9349. I tested this statement in a query:
Expr1: Sum(IIf([WAGE TYPE] Not In ("9348","9349"),[PAB_AMOUNT],0))
However, when I plug it into the control source of a text box, Access complains and says I have Extra ) in query expression.
That doesn't make sense because the format works on the query. What am I missing here?
I've tried:
=Sum(IIf([WAGE TYPE] Not In ("9348","9349"),[PAB_AMOUNT],0))
but same error.