Count Value in a report footer

[Guest]

I have a count expression in my report footer which counts the total number
of entries in my report.

I would like to display that value on the bottom of each page in my report.
When I move the expression to the page footer I get an error. Is there some
expression that I could place in the page footer that will show the value of
the expression in the report footer.

Any help would be greatly appreciated.

 

[Jeff Boyce]

You could create a control in the Page Footer section, and set the Control
Source of that control to something like:

=Sum([YourDetailField])

Note that this points to the FIELDNAME used, not the CONTROLNAME in the
Detail section.

Regards

Jeff Boyce
Microsoft Office/Access MVP