Here is what I have started with in that attachment,
I am having trouble with figuring this out in the 'Check Books In/Out' Form
**VBA challenge coding/getting amount owed if book is overdue
Need to subtract 2 date/time format fields and get a number
If that number is over (7 days) then a $.50 penalty is added for every day after 7 days
Any tips on this problem or anything else you think i could add or benefit from would be appreciated
Thanks
I am having trouble with figuring this out in the 'Check Books In/Out' Form
**VBA challenge coding/getting amount owed if book is overdue
Need to subtract 2 date/time format fields and get a number
If that number is over (7 days) then a $.50 penalty is added for every day after 7 days
Any tips on this problem or anything else you think i could add or benefit from would be appreciated
Thanks