Fine a student? (1 Viewer)

[croondevil]

I am currently working on a library database. and i want access to automatically fine a student $1 per day, if he fails to retun the book within the given time period.

I knw that this is possible using vba codes. but dont knw how to. Any help greatly appreciated

 

[namliam]

You can do a calculation quite easy with dates...
i.e. Date() - [ExpectedDueBack]
Will give you the number of days that he is late... multiply this by your $1 and you are done

 

[croondevil]

hehe..Why couldnt i think of this this is quite simple..Thx..i appreciate ur help

 

[namliam]

We all overlook the simple solution(s) sometimes....