Sum field in page footer

[John A.]

Hi -

Have a problem in an inherited db.

In the group footer section they have a field OrderTotal which is
"=sum([ExtCost])"

In the page footer section, they have a field whose controlsource is
"=[OrderTotal]".

When they print more than one PO, the field in the pagefooter section takes
the [OrderTotal] from the following record, not from the one displayed on
the page.

Can't figure out what's going on - any ideas?

Tnx,
John

 

[Allen Browne]

You cannot reliably sum into the page footer like that.

When Access calculates the report layout, it fits as many records as it can
on the page. Deciding what fits can be an involved operation: it depends on
what the actual data is (if controls and sections Can Grow or Can Shrink),
whether a section's Keep Together property is set, and the
inter-relationship between sections (e.g. a group header may have a property
set for keep with first, or keep all together.)

To figure out whether a section can fit on the page, Access has to advance
to the next record and try. It may then have to retreat. In fact, it may
need to retreat several records, or there may be a new grouping about to
appear. Consequently the question of which one is the "current" record is
not a clear issue. It is not reliable. From memory, I think it may not even
be consistent across the different versions of Access.