Search results

wow I'm an idiot. Brian thank you it works perfectly

Yes, exactly. [forms]![frm_Update].[textbox1] is where the date that the loan was taken out is entered and I understand why I don't want to use DateSerial(Now()) however it is saying there is an syntax error in update statement. UPDATE tbl_Loan SET tbl_Loan.DaysInMonth =...

I'm trying to design a database for my company that calculates interest paid on a loan based on the number of days there is left in that month. For example, if a loan is taken out on Jan 27, they have to pay 5 days of interest for that month (including the day the loan is taken out). So i'm...