Use vars from Detail section in Report Footer

[tsp120]

Hi,

I add up totals in the Detail section of a report, and I wish to use these totals stored in the report footer section of the report.

How do I call the Detail variables from the Report Footer?

Thanks,
Tim

 

[zrzr]

I think you put the total into a textbox no ?

So, if you want to access the value of the textbox, look at the name of this textbox and to find it's value, use
Me.nameofthecontrol.Value

If there's many record on the report, the value is the one of the last record !!!

 

[tsp120]

I didn't put it into a textbox. I could put it into an invisible textbox, but the report is starting to become cluttered and if I could just simply call the variable instead it would be a lot easier.

But thanks for your help.