sum multi record price

[SalmanZeiad]

=sum([price_out]) give error how to sum all parts price in subform

 

[SalmanZeiad]

 

[CJ_London]

if priceout is calculated in the form (i.e. price*quantity) you use

=sum(price*quantity)

also this needs to be in the form header or footer of your subform in a control called say sfInvValue

then on your main form you would use

=mysubformcontrolname.form.sfInvValue

 

[SalmanZeiad]

if priceout is calculated in the form (i.e. price*quantity) you use

=sum(price*quantity)

also this needs to be in the form header or footer of your subform in a control called say sfInvValue

then on your main form you would use

=mysubformcontrolname.form.sfInvValue

i want to give sum of total in marked cell

 

[CJ_London]

i want to give sum of total in marked cell

assuming your marked cell in on your main form - which it looks like from your image

then on your main form you would use

=mysubformcontrolname.form.sfInvValue

 

[SalmanZeiad]

assuming your marked cell in on your main form - which it looks like from your image

ok >>>put now by your code become give price not sum

 

[SalmanZeiad]

assuming your marked cell in on your main form - which it looks like from your image

=([Parts1].[Form]![P_out])

 

[CJ_London]

is that what you want?

 

[SalmanZeiad]

is that what you want?

i want to sum all prices in subform TOTAL PRICES

 

[SalmanZeiad]

is that what you want?

 

[CJ_London]

show the control you have on the subform footer

 

[SalmanZeiad]

show the control you have on the subform footer

 

[SalmanZeiad]

thank you,,,FINALY WORKED OK