R
Rob
Hi all,
In order to calculate each total payable including VAT I use on frmorders
(1st subform of frmcustomer) an expression in the control source of
=subfrmorderdetail.form!Ordersubtotal+Val(cboDelRate.column(2))
this is fine for my orders page but on the customers form I need a field
which I can calculate the sum of all monies ever paid to the company by the
customer.
Bearing in mind the expression takes values from -
1) Ordersubtotal which is a sum of the unitprice and quantity also a
percentage discount from each item purchased per order where applicable.
2) cboDelRate.column(2) which is a monetary value where a combo is selected
to work out the delivery rate. and then add this to the total.
How can I do this?
Thanks,
Rob
In order to calculate each total payable including VAT I use on frmorders
(1st subform of frmcustomer) an expression in the control source of
=subfrmorderdetail.form!Ordersubtotal+Val(cboDelRate.column(2))
this is fine for my orders page but on the customers form I need a field
which I can calculate the sum of all monies ever paid to the company by the
customer.
Bearing in mind the expression takes values from -
1) Ordersubtotal which is a sum of the unitprice and quantity also a
percentage discount from each item purchased per order where applicable.
2) cboDelRate.column(2) which is a monetary value where a combo is selected
to work out the delivery rate. and then add this to the total.
How can I do this?
Thanks,
Rob