For the benefit of anyone who stumbles into it as I have just done,
there is a syntactical error in the 'Working with Nulls and Zero-Length
Strings' help topic.  Under 'Nulls in Expressions' is offered the example :
=IIf(IsNull([Qtr1Sales],0,[Qtr1Sales]))+IIf(IsNull([Qtr2Sales],0,[Qtr2Sales]))
   that should read :
=IIf(IsNull([Qtr1Sales]),0,[Qtr1Sales])+IIf(IsNull([Qtr2Sales]),0,[Qtr2Sales])
   i.e. the IsNull function takes only one argument and then becomes the
first argument for the IIf function.
       There is a similar, but syntactically correct, example in the IIf
Function help topic.
... It doesn't work, but it looks pretty.
--- GEcho 1.12/beta+
---------------