How to auto gen. the number from report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan48 - 27 Jul 2005 09:05 GMT

I have over a thousand record in table. i want to check from table and
extract the specify records to report. but i want to add one more field in
report for easier to read. The field could be automated gen. the number from
1 to end. Would you helpand teach me how to do it or code it. thank you veryu
much

Reply to this Message

Allen Browne - 27 Jul 2005 09:53 GMT

1. Open your report in design view.

2. Add a text box with these properties:
Control Source =1
Running Sum Over Group

If you need to do this in a form, see:
Numbering Entries in a Report or Form
at:
http://allenbrowne.com/casu-10.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have over a thousand record in table. i want to check from table and
> extract the specify records to report. but i want to add one more field in
[quoted text clipped - 3 lines]
> veryu
> much

Reply to this Message