470,849 Members | 1,262 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 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 1607
358 Expert Mod 256MB
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, 103 views)
Mar 7 '21 #3
358 Expert Mod 256MB
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.

Similar topics

1 post views Thread by phjones | last post: by
1 post views Thread by Mubs | last post: by
1 post views Thread by paradox6996 | last post: by
3 posts views Thread by BarbaraB | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.