Report Returned Record Count

[Dermot]

How can I display the number of records returned from a report which source
is a query.

For example:
If my report returns 78 records over 4 pages, and each page has 25 records,
I would like page 1 to display "25 record", page 2 display "50 Records", page
3 display "75 Records" and page 4 to display "78 Records".

Any other suggestions I might consider regarding the display of the count
records returned would be appeciated.

 

[Marshall Barton]

How can I display the number of records returned from a report which source
is a query.

For example:
If my report returns 78 records over 4 pages, and each page has 25 records,
I would like page 1 to display "25 record", page 2 display "50 Records", page
3 display "75 Records" and page 4 to display "78 Records".

Any other suggestions I might consider regarding the display of the count
records returned would be appeciated.

Add a text box named txtLineCnt to the detail section. Set
its control source expression to =1 and its RunningSum
property to OverAll.

Then your page footer text box can use the expression:
=txtLineCnt

 

[Dermot]

Thanks for the reply Marsh
That worked a treat.

Add a text box named txtLineCnt to the detail section. Set
its control source expression to =1 and its RunningSum
property to OverAll.

Then your page footer text box can use the expression:
=txtLineCnt