Reports in Access 97

[qureshi]

I have to generate many reports from access 97 every month. The problem I am facing is that the summation of the quantity sold is not coming right.
The problem is quite complex to clearly state. I would like to know : Is there a way i can get hold of the label or textbox in the report and manipulate its value using Visual basic?
Something like storing the intermediate values of the quantity sold, Adding them in a variable and then posting it back to the report.

Thanks all