Print current record number on report

M

mike_mike

Hi

Simple question

i want to display the current record number in the detail section

with each record eg. [current record?] & "/" & sum(*)

eg
record# name
1/ 123 records john doe
2/ 123 records john joe
 
F

fredg

Hi

Simple question

i want to display the current record number in the detail section

with each record eg. [current record?] & "/" & sum(*)

eg
record# name
1/ 123 records john doe
2/ 123 records john joe
Click to expand...

Add an unbound text control to the report detail section.
Set it's control source to
=1
Set it's Running Sum property to Over All.
Name this control "RecCount".
You can make it not visible.

Add another unbound control to the detail section.
Set it's control source to:
=[RecCount] & "/ " & Count("*") & " records"
 
Top