Numbering Rows Help

[Lou]

I would like to number my rows in the detail section of a
report. How would I do this..?

Thank you.
Lou

 

[Rick Brandt]

I would like to number my rows in the detail section of a
report. How would I do this..?

Put a TextBox in the Detail section with a ControlSource of =1 and then set
the Control's RunningSum property to "Over all".

 

[Lou]

Thank you Rick.
That worked but now I have a different issue. I set it to
the group level, it won't start renumbering when it gets
to the new group it stays the same value. On overall it is
fine.. Any ideas..I would like it to number by section..

Thank you.
Lou

 

[Rick Brandt]

Thank you Rick.
That worked but now I have a different issue. I set it to
the group level, it won't start renumbering when it gets
to the new group it stays the same value. On overall it is
fine.. Any ideas..I would like it to number by section..

I don't think I've ever used the "Over Group" option, but I have always
assumed that it worked as expected. I've never seen a post indicating
otherwise. What sort of grouping do you have set up and where did you
place the TextBox?

 

[Lou]

The TextBox is placed in the detail window.

Only grouping I have set up is on my [DateReceived] in the
detail section which is set up by the week.

I have 3 group level. 1 Main Header, 1 sub header and then
detail section.

Hope this is what you wanted.
Thank you.
Lou

 

[Rick Brandt]

The TextBox is placed in the detail window.

Only grouping I have set up is on my [DateReceived] in the
detail section which is set up by the week.

I have 3 group level. 1 Main Header, 1 sub header and then
detail section.

I can only tell you that I just tried this on an existing report of mine.

Report Header
Page Header
Warehouse Header
Department Header
Detail

A TextBox with =1 and RunningSum "Over Group" placed in the Detail section
gives me an incrementing count that restarts at 1 for each change in the
Department group. (I'm using Access 97).

 

[Guest]

Heya'Rick.

I got it, I had to many levels for the Rolling Sum to pick
up. Their was a Header that had no data and a footer. Once
I removed these it kept the running sum to the specific
group. Works great.

Thank you for the help.
Lou

-----Original Message-----

The TextBox is placed in the detail window.

Only grouping I have set up is on my [DateReceived] in the
detail section which is set up by the week.

I have 3 group level. 1 Main Header, 1 sub header and then
detail section.

I can only tell you that I just tried this on an existing report of mine.

Report Header
Page Header
Warehouse Header
Department Header
Detail

A TextBox with =1 and RunningSum "Over Group" placed in the Detail section
gives me an incrementing count that restarts at 1 for each change in the
Department group. (I'm using Access 97).


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


.