By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 614 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Autonumber rows in reports

P: n/a
Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.
TIA
Denis
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
"Denbo" <de*****@optushome.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.


Put a control on the report with =1 as the ControlSource and then set the RunningSum
property to "Over All".
Nov 12 '05 #2

P: n/a
Thank you.
"Rick Brandt" <RB*****@Hunter.Com> wrote in message
news:bk************@ID-98015.news.uni-berlin.de...
"Denbo" <de*****@optushome.com.au> wrote in message
news:3f***********************@news.optusnet.com.a u...
Does anyone know how I can print a report that autonumbers each row/record it prints. Nothing complicated, just from 1 upwards.
Put a control on the report with =1 as the ControlSource and then set the

RunningSum property to "Over All".

Nov 12 '05 #3

P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

Use the running sum property of a TextBox. E.g.:

1. Set up a TextBox where you want the line (autonumbers) to appear
(usually in the Detail section).
2. Set the RunningSum property = OverAll
3. Set the ControlSource = "=1" without the quotes.

Each time the detail (or whatever section you selected) prints the
number will appear. The next line will increment the number by 1.

See the Access help topic on Running Sum.

HTH,

MGFoster:::mgf
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP2pciYechKqOuFEgEQIpBgCg2rlxfQe/gIkHqO9wuPRny6hoy2kAoI60
R/f+X6U0SaqASWxRs1BiA20d
=qFR8
-----END PGP SIGNATURE-----
Denbo wrote:

Does anyone know how I can print a report that autonumbers each row/record
it prints. Nothing complicated, just from 1 upwards.

TIA

Denis

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.