Hi, I am trying to use a SUM method inside of an IIF Statement.
Status: IIf([ScheduleT].[AmountDue]=[PaymentMade],"Current",IIf((Now())<[ScheduleT].[DueDate],"Not Yet Due",IIf((Now()),pastdue([ScheduleT].[DueDate]),"")))
I want the IIf([ScheduleT].[AmountDue]=[PaymentMade] to be...