Search results

i'm assuming you've just given up on this?

have you had a chance to have a look at the database as of yet?

here ya go mate. yeh, the main outline of the planned data base is that if you return the object late.. you incur a $5 late fee.. regardless of if it was 1 day or 20 days late. also, a $50 annual compulsory subscription fee that is due to be paid by members.. those of whom have been checked have...

sorry buddy, i dont entirely understand where to insert this coding. i remember coming across having to code certain things, but i cant remember where and how

hey guys, is there anyway to change the value of a checked or unchecked box in a yes/no data field... for example. for those of whom HAVE paid their subscription fee (therefore have the box checked in the "Fees Paid" field), they have $0 owing, and those who have yet to pay (unchecked box in...

ahhhhh, thanks again. yep problem solved.

cheers fellas, the code works perfect. by entering Late Fees Incurred: IIf([Returned Date]>[Due Date],5,0) into queries, it works perfect. how come it cannot read the returned date from the table... it prompts you (i know thats what happens with square brackets, i'm quite aware of that).

sorry, il clarify your questions. it must be returned on the day or before hand or the person is fined $5 (not per day, just one fee), i thought you would use it like so: Iif("Returned Date">"Due Date",$5,No Fees) but obviously not.

hey, my first question on these forums. i've had a look around but can't find a completely relevant solution to my question. for example, i have a book that is borrowed on the 07/08/08, it has a one week maximum borrowing time meaning it HAS to be returned before 14/08/08 otherwise you incur a...