Count Function in Access Report

[atiq]

Additionaly information. the =Count([StudentSurname]) works fine when i put it in the Detail section of the report in design view but displays #Error if i put the same box in Page Header or Footer.

any ideas how i can get this count function working from the Page Header or Footer while having the StudentSurname field in the Detail section of the report?

 

[pbaldy]

It won't work in the page header/footer; try in the report header footer. If you really want page counts, there is a way.