Sum In Report Footer

[djwasim]

Hello All

I am facing problem to sum up in report group footer of a field for example
i have some fields like.........


Qty(A)---Value(A)----Rate(A)---Qty(B)----Value(B)

5----------25---------5---------20---------100
10---------50---------5---------10----------50
12---------60---------5---------10----------50

I am using a formula in detail section to calculate the rate of (A) as
=Nz([QtyA]/[ValueA])

and i am using the formula in detail section to calculate the Value of (B) as
=Nz([QtyB]*[RateA])

Now When I want to sum Value(B) In Report Footer i am using the formulla
=Sum([ValueB])

But It dosn't Working and i dont get any result.

Plz Help ME As Soon As Possible

 

[RainLover]

You have to do all your calculations in the Query.

Not the Report.

 

[djwasim]

is there any other solution?

 

[RainLover]

Not that I know of.

Is this a problem?

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?t=167237&highlight=runningSum

 

[RainLover]

You have to do all your calculations in the Query.

Not the Report.

I should have added that although you do the Calculations in the Query you Sum the results of the Query in the Report.