468,117 Members | 1,423 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,117 developers. It's quick & easy.

How to show loan installment in OVERDUE

2 2Bits
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?
Mar 6 '21 #1
3 1442
225 Expert 128KB
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.
Mar 6 '21 #2
Akokoh Joel
2 2Bits
Pls I have the screen shot, I want to known how to show amount in overdue?

Attached Images
File Type: jpg IMG_20210307_055237_118.JPG (93.1 KB, 32 views)
Mar 7 '21 #3
225 Expert 128KB
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
Expand|Select|Wrap|Line Numbers
  1. IIf([Amount Paid]<[Amount Due],"OVERDUE","")
Mar 7 '21 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

By using this site, you agree to our Privacy Policy and Terms of Use.