Display total record in page footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi why does

=count(*)

give #error in page footer field but works in detail section ?

Q. i want to display the total records for the report in each page footer?
what the easy way to do this?

mike
 
Hi why does

=count(*)

give #error in page footer field but works in detail section ?

Q. i want to display the total records for the report in each page footer?
what the easy way to do this?

mike
Click to expand...

Place your =Count("*") control in the detail section.
Name this control "TotalCount"
Add an unbound control to the Page Footer.
Set it's Control Source to:
=[TotalCount]
 
Additional Question (for bonus points)

When the report has no rows, =count(*) give #Error

how do you suppress this!
 
Back
Top