IIF Syntax Problem (1 Viewer)

[Novice1]

I cannot figure out what is wrong with this syntax. Any help would be appreciated.

=IIF(IsNull[RSN_Increase]), “$ __________”, ("Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")

 

[MSAccessRookie]

I cannot figure out what is wrong with this syntax. Any help would be appreciated.

=IIF(IsNull([RSN_Increase])), “$ __________”, ("Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")

Unless there is a typing error, I think you might be missing a pair of parentheses (see above). Let us know if that makes any difference.

-- Rookie

 

[Novice1]

I'm still getting an error - Wrong number of arguments

 

[pbaldy]

Try

=IIF(IsNull([RSN_Increase]), “$ __________”, "Increase or restore my SGLI coverage to " & [RSN_Increase_Amt] & ". You must complete section 3, 4 and 5.")