Number records in detail

[fmt]

Hello,
How do we number records in detail section?something like

office center
1. td la
2. th chicago
3 tj phoenix
4 tk scity

Thanks

 

[Remou]

I guess the easiest way would be to use running sum.

 

[Pampers]

Hi fmt,
Create an unbound textbox in the detailsection of your report. Put =1 in the controlsource property of the textbox, and set the property Running Sum of the textbox to 'yes'. That should do it.


Pampers -

forgive my errors, just back from a holiday

 

[dhookom]

set the property Running Sum of the textbox to 'yes'.

The Running Sum property can be set to Over Group or Over All. I expect you want Over All.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Pampers]

Oeps.

Pampers -

you're neven too young to learn

 

[fmt]

Thanks dhookom , pampers....That worked