var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: MS Access Query Coding help
- Return No (PK)
- Returned Date
- Lending No (PK)
- To be returned date
- Fee (If Overdue. Per day)
I would like a code in ms access to calculate the number of days it has been since the overdue date. In addition, the code to calculate the total Fee.
Any help would be much appreciated.
You can use the DateDiff() function to calculate the number of days between two dates:
You can place this code in a query or VBA or even as the control source for a form or report control.
Thanks for the Code. I've been able to modify your code to my liking.
Tags for this Thread