Help with a calculated query field for late status, only partially works

[breakingme10]

My code works for the "Late" status but it won't show the "Unpaid"?

Status: IIf(Date()>[qry_Invoices].[DueDate],IIf(IsNull([qry_Invoices].[Payment]),"Late",IIf(IsNull([qry_Invoices].[Payment]),"Unpaid","Paid")))

This is in a query for invoices to set the "Status" of an invoice to paid unpaid or late.


EDIT: it still won't show "Paid"

[breakingme10]

Of course i spoke too soon, this worked

Status: IIf(Date()>[DueDate],IIf(IsNull([Payment]),"Late",""),IIf(IsNull([Payment]),"Unpaid","Paid"))

[June7]

Try:

Status: IIf(IsNull([Payment]), IIf(Date()>[DueDate], "Late", "Unpaid"), "Paid")

[breakingme10]

Status: IIf(IsNull([Payment]), IIf(Date()>[DueDate], "Late", "Unpaid"), "Paid")

Worked perfectly! Can't believe how just switching the first iif statement to the payment being null instead of date makes such a difference!