Sum in report better explained

[David]

Here is a clearer explanation.

Here is a picture of the report I am working on.

http://www.almarsupplies.com/invoice.jpg

The purple field is summing all the weight of the red field. The green
field is multiplying the summed weight times the price in the yellow field.
I need to now sum the green field and put the value in the blue field.

I did make a field above the red field that would sum the weight * price and
that seems to work well, but it doesn't take into account price errors or
discrepancies. I would like to be able to sum the green field and compare
it to my other summed field to check for errors. Does anyone know how I can
sum the green field? There could be many of these forms per invoice.

Thanks,

Dave

 

[John Vinson]

Here is a clearer explanation.

Here is a picture of the report I am working on.

http://www.almarsupplies.com/invoice.jpg

The purple field is summing all the weight of the red field. The green
field is multiplying the summed weight times the price in the yellow field.
I need to now sum the green field and put the value in the blue field.

You can sum Fields in the form's Recordsource - but you cannot sum
Textboxes.

Do the calculation in the Query upon which the form is based, and sum
that calculated field.

John W. Vinson[MVP]