How to show loan installment in OVERDUE

[Akokoh Joel]

Loan amount of 20000 was given out to be paid in 4months, 5000 each
The first month 5000 was paid, but the second month was not paid.
So how can it be done such that the 5000 for second month will appears as OVERDUE.
which query can do that?

[isladogs]

The answer depends on the fields you have in the relevant table.
Please provide field names and datatypes and/or a screenshot so someone can assist properly.

[Akokoh Joel]

Pls I have the screen shot, I want to known how to show amount in overdue?

[isladogs]

Assuming your table field names contain spaces as indicated in your screenshot, then, to show the text OVERDUE, you could add a query field with this expression

IIf([Amount Paid]<[Amount Due],"OVERDUE","")