Summing an unbound textbox

fat controller

Slightly round the bend..
Local time
Today, 23:18
Joined
Apr 14, 2011
Messages
758
Is it possible to subtotal an unbound textbox on a report? I have a textbox which itself contains a calculation as its data source =([txtRateForYear]*52)

Now, if I have a record that has that field a number of times, is there a way to have a subtotal at the end of each record, and then an overall total in the report footer?
 
You can't sum the textbox, but you can sum the calculation. You can also move the calculation to the report's source query, giving you a field you can sum.
 
Just got back in, and come to post exactly that - I had one of those "Ah, ya silly auld git..." moments to myself whilst sat at some traffic lights :D

I should think slower, and post less.... :o

Thanks
 
No problem. A lot of good thinking happens at traffic lights. :)
 
I do seem to have a tendency to solve things whilst stuck in traffic.... or in the bath.... or in the middle of the night :D
 

Users who are viewing this thread

Back
Top Bottom