How to display the first record and last record in a page of a report?

[Jacelynpan]

Say for example I have a set of records in the database with a running serial number (which assigned during the report runtime and not include in the database) for every record.

For every page (or the footer of the page), I need to display the serial number that indicate the first and the last record IN A PAGE. (assuming each page has a maximum of 25 records)
Eg. A000001 - A000025 (to be displayed in the footer of page 1)
A000026 - A000050 (to be displayed in the footer of page 2)
A000051 - A000060 (to be displayed in the footer of page 3, assuming that page 3 has only ten records)

Can somebody help me...coz I'm a newbie in MS Access.

Cheers!

 

[CosmoKramer]

Check out the Microsoft Knowledge Base Article - Q153029: Displaying First and Last Record Per Page in Page Footer.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q153029

This should be what you're looking for.....