Count records per page

[Suresh_Murugan]

Hi dears,

Please solve this !!!

How to count detail section records page wise ???

I want show page footer section

Records: 1 to 14 of 30 Page: 1 of 2
Records: 15 to 30 of 30 Page: 2 of 2

Please help me.....

 

[isladogs]

To count all the records on a report, add a textbox to the report footer and type :

=Count(*)

To count the records on each page, see this link: http://allenbrowne.com/ser-11.html

To show the page info, type this in a textbox in the page footer section:

="Page " & [Page] & " of " & [Pages]

 

[Suresh_Murugan]

Thanks for reply.

But i not get a answer.
I want as per attached snapshots

Please !!!!!

 

[isladogs]

I don't know if you looked at the link on Allan Browne's website.
With his code & what I supplied, you have more than enough to work out the rest for yourself

I gave you code to give e.g. Page 1 of 8, Page 2 of 8 etc

As for record count:
If there are 16 records on page 1 (using Allan Browne's curTotal) and 93 in all using Count(*), you should easily be able to do a formula to give:

Records: 1 to 16 of 93

To do this, add a hidden textbox in the header: curStart and make the record source

=curTotal

For the textbox in the footer:

"Records: " & (curStart+1) to " & curTotal & " of " & Count(*)

For the next and subsequent pages, DON'T reset the curTotal to zero
So Page 2 will have curStart=16 and a further 16 records making curTotal =32
The textbox in the footer will still work using the above formula