how do i apply a lumb somme payment in to differents months

[formula in query]

suppose every member in my club suppose to pay $10.00 every monthe.Jhon payed
$120.00 in april how to i distribut that amount in to those differents
account of the year ? thank you for your help

 

[John W. Vinson]

On Tue, 25 Aug 2009 23:14:09 -0700, formula in query <formula in

suppose every member in my club suppose to pay $10.00 every monthe.Jhon payed
$120.00 in april how to i distribut that amount in to those differents
account of the year ? thank you for your help

That depends entirely on the structure of your database and the relations
between your tables - which you have chosen not to post. Give us some help
here?

Normally in an accounting system you'll have separate records for debits and
credits, and total them up. If Jhon (or John for that matter) has run up
twelve $10 debits and has one $120 credit, then a sum will be 0. It's not
normally necessary or appropriate to convert one $120 payment into twelve
"phony" $10 payments.

 

[formula in query]

thank you John. I do not have debit and credit account.i have table of
members (id,name,addresses.ect..) related to a table
Payment(id,name,paymentterm wich i us for january february so on
,pmtType,ect..)I am trying if possible to enter a single payment in Form wich
is going to be able to go in the payment table credit for january february if
not payed.if it is then go to the following month so on.The monthy payment
may be different from the others;like this year january and february the
payment was set to $30.00 ,March to may $15.00 and from then it $10.00.we
change it by vote. If you know for thinks like this some pay late and some
pay a estimeted amount for the year.
if it was possible i could send you the structure .hoping your help
Thank you