=sum(iif([CheckNo]=0,1,0))

  • Thread starter Thread starter Wei Wang
  • Start date Start date
W

Wei Wang

the expression is in report group footer. when I open the report, access
tells "the expression is typed incorrectly, or it is too complex to be
evaluated. for example,
a numeric expression may contain too many complicated elements. Try
simplfying the expression vy assigning part of the expression to variables."

strange message. I can do this expressin without problem.
=sum([TransAmt]*iif([RecCode]='R',1,-1))
 
I just tried =sum(iif([CheckNo]='0',1,0)), it worked.

CheckNo is a numeric field. why it needs the single quote.
 
Back
Top