How can generate numbering in Access Report ?
ie.

I want to generate report

select * from employee

1 Martin
2 Jones
3 Peter
...


regards.

Mateen

Place an unbound textbox in the detail section of your report. In the recordsource property of the textbox, put "= 1" (no quotes). Set the Running Sum property equal to YES. When you run your report, you should see numbering.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

thanks for your response.

I am using Access 2002

In my Access the Running Sum propery not mention YES
the Running Sum property mention No, Over Group and Over all
option.

I could not find recordsource property of the textbox, put=" 1"
where I mentioned textbox, put=" 1" ?

Please guide how can find it, and how can
geneate numbering in Access Report 2002 ?

Regards.

Mateen

Sorry about that. I mean CONTROL source, not RECORD source. I always interchange the two words by accident. In the Control Source of the unbound textbox, enter

=1

And set the Running Sum property to YES.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

The Running Sum property Over Group would be used if you have your report Grouped. You would probably use the Over All setting.

thanks a lot