Print current record number on report

[Guest]

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

 

[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

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"

 

[witharebelyell]

Brilliant !