How to count the total records on a particular page

  • Thread starter Thread starter Irshad Alam
  • Start date Start date
I

Irshad Alam

I want to count total number of record on a particular
page at Page footer. As all the pages of my report does
not carry the same amount of records . I tried to put a
text box on page footer and on control source I wrote :

=Count([Namees])

The result is #Error#.

I cannot put the text at Report footer as it will count
all the records, I just want to count pagewise, that how
many records are there on that particular page. For
example , page 1 has only 21 records, Page 2 has 35
records and so..on. Therefore, I want to put a text box at
page footer to view the result.

My record to count the records on the page footer of each
page seprately.

Please advise.
 
Irshad said:
I want to count total number of record on a particular
page at Page footer. As all the pages of my report does
not carry the same amount of records . I tried to put a
text box on page footer and on control source I wrote :

=Count([Namees])

The result is #Error#.

I cannot put the text at Report footer as it will count
all the records, I just want to count pagewise, that how
many records are there on that particular page. For
example , page 1 has only 21 records, Page 2 has 35
records and so..on. Therefore, I want to put a text box at
page footer to view the result.
Click to expand...


Not a simple question. Here's an article that discusses an
approach to doing this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;296249&Product=acc
 
Back
Top