help with a calculation..

B

Brook

hello,

I have a frminvoices, with two subforms ((1)frminvoicedetails subform &
(2)frminvoicepayments subform)

Subform (1): I use to enter new orders for my invoice, it contains an
invoicesubtotal calculated field and a shippingtotal calculated field

frminvoices: field to copy to the invoicesubtotal, and shippingcost from the
subform (1), then another calculated field invoicetotal.

What I need to do is after the invoicetotal is calculated, populate the
invoicetotal field in my subform(2) for payment acceptance.

Once this is established, I have the subform(2) set up to accept payments
: pmtdate, pmt#, pmtamt, and balance due fields.

I would like for the first payment to be deducted from the invoicetotal,
then then next payment would be deducted from the Balance due.

Any ideas ? Suggestions?

Thanks in advance..

Brook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top