I have an expression in an unbound field on a report. I'm getting a syntax error. I need it to count the 'Command' data if it is null or contains a 0.
=Count(IIf(IsNull[command],0,(IIf([Command]=0,0))))
Where am I getting it wrong
I have an expression in an unbound field on a report. I'm getting a syntax error. I need it to count the 'Command' data if it is null or contains a 0.
=Count(IIf(IsNull[command],0,(IIf([Command]=0,0))))
Where am I getting it wrong
Last edited by Huddle; 03-07-2012 at 04:16 PM.
No parentheses for the IsNull function:
IsNull(Whatever)
thanks for your help