IIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to write a IIF statement based on whether or not a field on the
subreport [TotalPayments] is null.

IIf((IsNull)srpt_PaymentDetails.Report!TotalPayments,"","PAST DUE")

This is not working.

Any help would be appreciated
 
Check your syntax of Isnull, it should read something like
IIF(IsNull(srpt_PaymentDetails.Report!TotalPayments),"","PAST DUE")
 
Back
Top