Positioning a total field

[allanon]

I have a report that is like an ivoice where the final total (in the report footer) must be located in a certain position just above the page footer. Any ideas on how I can do that?

 

[Maquis]

So, they've installed Access at Paranor now. Now you can properly catalog all those Druid Histories. Should be interesting.

Anyways, I haven't tried it, but I believe this should work. Create a text box in your report footer called GrandTotal or something like that which contains the proper calc for your total. Next create a text box in your page footer positioned just where you want it. Set the recordsource on that box = GrandTotal. Now you can make the box in the Report footer invisible and only have it shown in the page footer.


Maq B-)
<insert witty signature here>

 

[GIA]

My only idea involves subterfuge

Bury both in the page footer, oriented as desired.
Set a Boolean when you hit the end of the report (bFoo).
In the page footer, use iif(bFoo, (your content here), &quot;&quot

My other idea was to toggle off invisibility on the &quot;secret&quot; control when end-of-report is triggered. -------
&quot;What is your favourite colour?&quot; &quot;Blue! No! Yell&quot;