Why is Access Complaining about This Function??

[TWD]

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.

[bcofie]

tRY THIS AND SEE
=IIf( [WAGE TYPE] Not In ("9348","9349"),Sum([PAB_AMOUNT]),0 )

[TWD]

I got it working finally with this:


=Sum(IIf([WAGE TYPE] In ("9348", "9349"),[PAB_AMOUNT],0))