I am in need of syntax clarity for having (2) arguments within a IsNull statement.
The section that is colored red is to return a blank space when both data fields 'min & max' are empty or equal to 0.



Here is what I have right now  -  the red section is where I'm getting errors from: 



If IsNull ({limits.limit_imin_l1_t9}) or ({limits.limit_imin_l1_t9} = 0)
Then
'NMT-' + ToText(ToNumber({limits.limit_imax_l1_t9}), 0) + '%'

Else If IsNull ({limits.limit_imax_l1_t9}) or ({limits.limit_imax_l1_t9} = 0)
Then
'NLT-' + ToText(ToNumber({limits.limit_imin_l1_t9}), 0) + '%'

Else If IsNull ({limits.limit_imin_l1_t9}) or ({limits.limit_imin_l1_t9} = 0) and
       If IsNull ({limits.limit_imax_l1_t9}) or ({limits.limit_imax_l1_t9} = 0)
Then
' '

Else
ToText(ToNumber({limits.limit_imin_l1_t9}), 0) + '-' + ToText(ToNumber({limits.limit_imax_l1_t9}), 0) + '%'



Edited by Stephen W. - 30 Apr 2009 at 1:15pm

Thank you very much!

It worked!




I went for 13+ years without writing any code.  It's been a while.