Sum Funtion "Formula" does not display answer in Report

[rxm01l]

I'm in a complete lost, something that should be easy, but I can't get answer.. I have an access report that there is One column among 9 of them, refuse to give answer.. Its suppose to Sum all the total of each line in the column. See Attachment. This report is group by ID and sort by Shift. The formula is: Sum([Rates]), and the Rate is list in Details Report where the Sum ([Rates]) is located in Id Footer section. "see attachment". What did I don wrong here?.. any idea would be so greatful..

FYI, when I ran this report, it does not know what the Rate is. However, the rate is the formula which listed accordingly in the report details..I hope this clear to everyone..

Thanks

 

[pbaldy]

You can't sum a calculated control. You can either move the detail calculation out to the report's source query, or sum the calculation:

=Sum(Quantity * Rate)

type of thing.

 

[rxm01l]

Thanks I got to do this other way..Thanks

 

[pbaldy]

No problem.