Summing calculated fields

[George]

Good Day All.



Can anyone instruct how to sum a calculated field?

My records are form a query and group on a field "Student". I added a calculated field "text2"in the details section; now I want to sum up the results of all the records for that field.

Under the Student Footer Section a placed another calculated field "text3" under the "text2". Using the expression builder I entered: =sum([text2]). This generated an error message.

Any help would be appreciated.

[pbaldy]

You can move the calculation to the source query or sum the calculation:

=Sum(Quantity * Price)

[George]

Good Daypbaldy. Thanks again. It worked by moving the calculations to the source query. However are you also saying that it could have worked without going to the source query?

[pbaldy]

Yes, using a textbox with a control source like I posted, summing the calculation.