Report total on detail field

[ronphx]

I'm creating a report that shows trial balance from a query. I take the beginning balance + transactions, and in my detail report area I create a field called TxtEndingBalance. In the report total, I'm creating a text box to add up all the balances in the TxtEndingBalance fields. My problem, and I've run into this before, is that the value in my control box is =sum([TxtEndingBalance]), and the report doesn't recognize the name TxtEndingBalance. It gives a box asking for the value. Is there a way to have the report total recognize a text box created in the detail area?

I know in the report total I could (and have) use the original fields from the query to get the total, but I'm curious why the report totals don't recognize text boxes created in the detail area.

Thanks.

 

[dhookom]

You can't use aggregates of "controls" across sections. You could get the final value of the control with a control source of:

 =txtEndingBalance

I expect the ability to aggregate controls required too many resources.

Duane
Hook'D on Access
MS Access MVP

 

[ronphx]

Thank you. I was afraid of that. It looks like I'll go back to the old fashioned way and modify my query. It's not that big of a deal.

Thanks again.