Incremental Number in Detail Section 1

[TudorSmith]

Hi,

I have a report in which I would like a label to show a number. For each page (About 24 pages are returned), there are three records show. I would like a lable that shows, 1, 2, 3 ... 24 for each record.

I cannot use the ID of the recordset, because the numbering should always start at 1.

Is there a way to place a lable (or field) and have it start at 1, then increment each time another recorded is displayed? Do I need to add a field in my query (highly likely I think)

Thanks

birklea birklea ~©¿©~ <><
I know what I know...don't presume that I know what I don't! Smithism!!!

 

[CosmoKramer]

Add an unbound text box to your detail section. In the text box's properties, define the following controls:

ControlSource: =1
RunningSum: Over Group

This should be what you're looking for.....

 

[ahmun]

Something so simple... yet effective!

And this post happened on my Birthday!


I give you a shtar!

Earnie Eng
If you are born once, you will die twice
If you are born twice, you will die once