clare_voiant
Board Regular
- Joined
- Mar 20, 2002
- Messages
- 76
this is what i have
column1 - no of installments i.e 10
column2 - amount per installment i.e. £100
column3 - payment start date i.e. 15th march 2002
column4 - last payment date i.e. 15th Dec 2002
column5 - now()
column6 - paid to date ????????
i would like to know how to calculate how much money we have now for account reconcilliation, and (even on a future date) the paid to date column should not read more than £1000
can anyone help?
column1 - no of installments i.e 10
column2 - amount per installment i.e. £100
column3 - payment start date i.e. 15th march 2002
column4 - last payment date i.e. 15th Dec 2002
column5 - now()
column6 - paid to date ????????
i would like to know how to calculate how much money we have now for account reconcilliation, and (even on a future date) the paid to date column should not read more than £1000
can anyone help?