Looping in Access

[ducthang88]

This is my scenario:



dateborrowed(text)
=date()

duedate(text)
=[date()]+3

fine/penalty IS MY PROBLEM
--> i want this like for everyday after duedate a 5$ penalty for each succeeding day with a penalty cap of 30$ somthing like that.. (textbox updates everytime)

example

dateborrowed - Aug 1 1990
duedate - Aug 4 1990
fine = 5$ (august 5)
=10$ (august 6)
=15$ (aug 7)
=20$ (aug 8)
= 25$ (aug 9)
=30$ (aug 10)

[pbaldy]

I don't think you need a loop. You can use the DateDiff() function to count the number of days between the due date and today, and multiply. Also, why would you use text fields to hold a date? That will likely be problematic.

[ducthang88]

oops sorry it is date not text my bad... datediff() eh?