I assume the invoice total is calculated as the sum of a number of
individual items (or price * quantity) and a percentage added somewhere
along the line for tax That tax rate should be held with the invoice in case
the government raise it, or lower it!! Who said newsgroups are all serious).
So the total invoice can always be recalculated and the balance can be
recalculated.
Suggest you have a form with the main invoice details such as Name address,
invoice no, date VAT (Tax) rate, etc
A sub form InvoiceLines which has all the individual items purchased:- price
quantity and unbound field of price * quantity and total on the form footer
A second subform Payments:- amount, date, and total on the form footer
Then the main form can show the balance as difference between the total on
the InvoiceLines Subform and the Payments Subform
Phil
"DS" <bo******@optonline.net> wrote in message
news:o8*****************@fe08.lga...
Phil Stanton wrote: I would suggest that generally it is a bad policy to store calculated
values
Have your original Bill (Invoice) of $10, with an InvoiceID.
You then have a table or payments with PayID, InvoiceID, AmountPaid &
Date. Use a Query to add up the payments for a given InvoiceID, subtract
the total from the original invoice amount, and that is what is still
owing.
If you do it your way and mispost a payment, then after correcting it you
will have to adjust the outstanding amount. If you get it wrong on the
first payment, you will have to adjust all subsequent records.
HTH
Phil
"DS" <bo******@optonline.net> wrote in message
news:HP****************@fe08.lga...
I have a continous form that records payments. I' starting out with a
bill of lets say $10.00. What I want to happen is that when I apply a
payment a new record is made. In that new record I want the remaining
amount left
from the $10.00 to appear in the new record. Lets say I apply $6.00, I
want a new record with $4.00 in it How would I pick up the value
remaining and apply it to the new record.
Thanks
DS
I agree about storing calculated values. The only problem is that the
invoice total is also calculated. I have tis amount hanging around so to
speak on a unbound field on the form. How do I get the form to make a new
record with this adjusted total? People will be entering various amounts
to each payment record so I want the new record to reflect the balance so
to speak in the paymount amount field. Any examples of this out there?
Thanks
DS