Sum of Records in Access

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

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.