G
Gerard Mears
Hi,
I have the following report set up.
Page Header information
Page Detail
Page Footer.
In the footer I have calculated the total for a field for each page.
That is, it adds the total amount for field one on page 1 then resets
to zero and recalculated the total for page 2 and so on. I use VB
code in the detail part of the the form to calculate this total.
The page footer VB code then populates an unbound control with the
total from the detail section. I need the same total in the Page
Header as well.
The problem is that the page header total always displays the previous
pages total. I have tried using =[total from footer control] and
populating the total in the header from the VBcode in the footer.
Both provide incorrect results.
Anyone know of a way around this?
Thanks
I have the following report set up.
Page Header information
Page Detail
Page Footer.
In the footer I have calculated the total for a field for each page.
That is, it adds the total amount for field one on page 1 then resets
to zero and recalculated the total for page 2 and so on. I use VB
code in the detail part of the the form to calculate this total.
The page footer VB code then populates an unbound control with the
total from the detail section. I need the same total in the Page
Header as well.
The problem is that the page header total always displays the previous
pages total. I have tried using =[total from footer control] and
populating the total in the header from the VBcode in the footer.
Both provide incorrect results.
Anyone know of a way around this?
Thanks