I have a report whose sorting and grouping is set to DepositDate Acscending
The report has aDepositDate Header [DepositDate]. If Deposit Date is blank, it lists all the records that have no deposit dates and then breaks properly on those records that have DepositDates.
I am trying to get the DepositDate Header to print "No Deposit Date" for those reords that do not have a Deposit Date
I tried Nz([DepositDate], "No Deposit Date") and
IIf(IsNull([DepositDate}, "No Deposit Date", [DepositDate])
and neither accomplishes what I am trying to do.