Calculation Of Calculated Field in Report

[Malik via AccessMonster.com]

Hi,
I have a Debit TextBox which has the calculated Valu From a Query.
Now I Want to Do Sum Of this Text Box

When I Use =Sum([Name of TextBox])

It Shows Error on Report

Plz Tell me how to calculate it

Thanks

 

[Philip Herlihy]

Hi,
I have a Debit TextBox which has the calculated Valu From a Query.
Now I Want to Do Sum Of this Text Box

When I Use =Sum([Name of TextBox])

It Shows Error on Report

Plz Tell me how to calculate it

Thanks

For this to work, the textbox for the Sum must be in a footer - it can
be the page footer, or a report footer, or a group footer. Is that
what's missing?

I've never played with this (must go off and try it now!) but you can
also have a Running Sum, which I understand means that (like a bank
statement) you get a cumulative total for records so far.

Update: I did try it - took about 3 minutes to create a simple query
including a "cost" quantity from one of my tables, then used the report
wizard to lay out a simple tabular report. I chose landscape mode to
make sure I had a bit of spare room, and didn't ask Access to fill up
all the space (check box). Then, with the report in Design view, I
copied the "cost" box, moved it to the right of the existing one, and
changed the "running sum" property to Yes. Bingo - a bank statement.
Isn't Access wonderful?

Phil, London

 

[KARL DEWEY]

The aggregate functions (Count, Sum, Min, etc) are query
functions. They can only operate on *fields* (columns) in
the report/form record source table/query. They are unaware
of *controls* (text box, etc) on the report/form.

To do what you want, sum an expression like:
=Sum(QueryField)