How do I add running numbers in a report in Access?

G

Guest

We use an Access 2K DB to organize our projects. A Report is defined based on
a Query showing projects assigned to the job captain. I need to add a column
to the Repor Form displaying the running numbers from 1 up to the number of
records on the Report, e.g.:
1 jobcap1 proj1
2 jobcap1 proj2
...
20 jobcap4 proj3

Thank you for your support.
 
A

Allen Browne

Just place a text box on your report, and set these properties:
Control Source: =1
Running Sum: Over Group
 
G

Guest

Exactly what I asked for! Much obliged Allen!

Allen Browne said:
Just place a text box on your report, and set these properties:
Control Source: =1
Running Sum: Over Group
 

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

Top