Report Returned Record Count

  • Thread starter Thread starter Dermot
  • Start date Start date
D

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.
 
Dermot said:
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.
Click to expand...


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
 
Thanks for the reply Marsh
That worked a treat.


Marshall Barton said:
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
Click to expand...
 
Back
Top