Hi

I have a report that will get the last record from a set and display it on the report:
=Last([Balance])
I have called that text box "txtClosingBalance"

So it will show the balance at the end of a date period

then i want to do a sum on the fields displayed on my report at the end:
=Sum([txtClosingBalance])

So that way it will calculate the total of the fields displayed only on the report not all the balance fields in the query.

However it does not work like i thought it would.
When i run the report it brings up "Enter Paramiter Value" txtClosingBalance

How can i get around this?

Thanks

You can not Sum a control value ... you must Sum the field value ...

RDH

Ok then

Is there another way?

the data is something likethis

Date | Department | Count Items | Transaciton Price | Balance
1/1/05,Dept1,1,-$1.00, $9.00
2/1/05,Dept1,2,-$2.00, $7.00
3/1/05 Dept1,5,-$5.00, $2.00
3/1/05 Dept2,1,-$1.00,$9.00

Report

Department | Total Count Items | Total Transactions | Remaining Balance
Dept1, 8, $8.00, $2.00
Deot2, 1, $1.00, $9.00
-----------------------------
Totals,,9,$9.00,$11.00

BTW, Its a very large database and when i try in something like a query it takes so long the OBDC Connection times out,

Edited by: neo_m on Sun Nov 13 23:24:23 EST 2005.