expression

[PJ]

I have the following expression:

Deal Types: IIf([Customer].[Payoff Date]>=[customer].[close date],"Pay
Off","New Deals")

I also want the expression to show all null values for payoff date. Where
would I put that in my expression??

 

[John W. Vinson]

I also want the expression to show all null values for payoff date. Where
would I put that in my expression??

Assuming that you want NULL payoffdates to show as New Deals, try

Deal Types: IIf(NZ([Customer].[Payoff Date],#1/1/100#)>=[customer].[close
date],"Pay Off","New Deals")