hey i need to know how to do a IIF function in Access with this date below
A fine of £0.20 per school day is charged to borrowers who return books after the Due date. If a book is returned more than fourteen school after the due date there is an additional £1.00 charge.
examples:
if a book is due back on friday and is returned on the following monday, the fin is £0.20
If a book is due on wednesday the week before half term and is returned on the Tuesday after half term, the fine is £0.80.
so i need a IIF function to do that any help with be much appreciated.
A fine of £0.20 per school day is charged to borrowers who return books after the Due date. If a book is returned more than fourteen school after the due date there is an additional £1.00 charge.
examples:
if a book is due back on friday and is returned on the following monday, the fin is £0.20
If a book is due on wednesday the week before half term and is returned on the Tuesday after half term, the fine is £0.80.
so i need a IIF function to do that any help with be much appreciated.
Last edited: