Print current record number on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting records 0
sequentally numbering records in a report 2
Make links into records on a report 7
Record count in report w/o records 9
Query design 0
Count limits 8
Printing a report with consecutive pages 1
Trying to print current record 1

Back
Top