Hi all,
I have a subform situated in a main form, Its a db that monitors sales.
The main form is based on an orders table.
The subform is the order details.
Within the subform are Qty, Unit Price and Discounted Price fileds.
I have the form/subform working correctly when totaling the sum of the order, eg...
in the subform is a field called total price which has the following as the control source
=Nz(Sum(qty * unit price))
then in the form is a filed called total that has =[total price]
this works really well.... as the subform updates, so does the main form
my problem is that I want the form to use the following =Nz(Sum(qty * unit price)- Discounted Price)
then in the form i thought this value could be displayed dynamically. As the subform updates, the form updates dynamically too!...just as it did before...
any help is greatly appreciated....
I have a subform situated in a main form, Its a db that monitors sales.
The main form is based on an orders table.
The subform is the order details.
Within the subform are Qty, Unit Price and Discounted Price fileds.
I have the form/subform working correctly when totaling the sum of the order, eg...
in the subform is a field called total price which has the following as the control source
=Nz(Sum(qty * unit price))
then in the form is a filed called total that has =[total price]
this works really well.... as the subform updates, so does the main form
my problem is that I want the form to use the following =Nz(Sum(qty * unit price)- Discounted Price)
then in the form i thought this value could be displayed dynamically. As the subform updates, the form updates dynamically too!...just as it did before...
any help is greatly appreciated....
