Identifying records....

[Tomin]

Is there any way to identify the last record that is on a report? If I put the field (example: name) in the header of a report, it will show the first record on that page of the report. However, I also want to show the last record that is on that page of the report. Is there any way to identify it, or perhaps even identify the first record on the next page and using an expression to calculate the record before it?
I appreciate any thoughts on this, it's starting to drive me crazy.

Thanks!
Tomin

 

[PaulF]

This article shows how to do it in the page footer

Article ID: Q208412
ACC2000: Displaying First and Last Record Per Page
in Page Footer


Even though it says it is for 2K, I did it in 97.

PaulF

 

[Tomin]

Thanks Paul,
Where do I find that article?

Tomin.

 

[Tomin]

found it, thanks

Tomin

 

[Tomin]

I found the solution. Actually there's a very helpful example in the Solutions.mdb specifically for this problem. In that database, the CustomerPhoneList is intended to specifically address this issue. Just thought I would post this in case anybody else comes across this thread looking for the same answer.

Thanks to PaulF for your post, it does work IF you want the results in a footer, but not a header. To do it in a header, you need to force double formatting evaluation (using a field for =[Pages] in the footer to force the double evaluation even though I set the visible property to no since I didn't want that info on the report).

Hope this helps somebody else and thanks to those of you who tried to help me

Tomin