IIF Function in access

L

laura22

Joined
May 6, 2011
Messages
1
Reaction score
0
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. :)
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to use the IF and SUMIF function on Excel 8
nested iif function 4
Access MS Access 2010 IIF statement to check if one date is in or out of range of two other dates (fields) 0
Access Dcount function in access 0
Countif Function?? 3
Iif function for query 3
Access Building a IIF expression in Access 0
IIF statement 6

Top