Sum of Records in Access

[nileshhthakur2004]

Hi all,

i am workin on access report in which i am displaying the division of two field and display it in one textbox as follows

control name TextSkids
ControlSource =([RequestedQty]/[NbrPerCase])

this show me right out put value on each rows

now i want to do sum of this all value

so i take one Textbox as TextSum

controlName TextSum
ControlSource =Sum([TextSkids])

but it ask me parameter when i run the report and display worong out put

pls help me regarding this ..

thanx and regards

[DKenny]

Nilesh
Division is not additive. You would not get the correct answer, even if you got this control to work.
You will need to add 2 more (hidden) controls, one to be the sum of NbrPerCase and the other to be the sum of RequestedQty. then TextSum will be the result of the division of these 2 controls.