Working out Fines for library

  • Thread starter Thread starter Marko
  • Start date Start date
M

Marko

My Library database which I am building requires me to
work out fines. Fines are charged to borrowers who return
books after the due date for return. The fines applied
are:

£0.30 - [seven days late over and including]
Additional £0.30 - [14 days late over and including]
Additional £0.40 - [21 days late over and including]
Aditional £0.50 - [28 days late over and including]
Additional £1.50 - [56 days late over and including]

I have a Loan Date field, Loan Due field and Returned
Date date field what would the formulae be to work out
these fines?
 
I would expect these amounts and/or intervals to change over time so I would
not hard-code an expression. Consider creating a table:
tblFineRates
================
finFinID autonumber primary key
finFromDays numeric
finToDays numeric
finAmount Currency

You could then add in your day ranges and fine amounts into the table. You
can then add this table to your query and create a calculated column
DaysLate: DateDiff("d",[Loan Due], [Returned Date])
set the criteria under this expression to
=finFromDays AND < finToDays
Click to expand...

--
Duane Hookom
MS Access MVP


My Library database which I am building requires me to
work out fines. Fines are charged to borrowers who return
books after the due date for return. The fines applied
are:

£0.30 - [seven days late over and including]
Additional £0.30 - [14 days late over and including]
Additional £0.40 - [21 days late over and including]
Aditional £0.50 - [28 days late over and including]
Additional £1.50 - [56 days late over and including]

I have a Loan Date field, Loan Due field and Returned
Date date field what would the formulae be to work out
these fines?
 
Back
Top