Running Totals (s.no) - Report - Access 2003

[Ignorant]

Hi,
Iam having trouble adding s.nos to the group header.
The group header has one or more rows in them. I want to have a s.no incremented only on the group header, ignoring the records it contains.
I added a textbox and set the control souce to =count([Member]![fName]) and set the running sum to Over group.
But it starts counting the GH+REC1+REC2+REC3...
So if first group has 2 records, the next group has s.no. 4?!? i.e GH+REC1+REC2.
Iam attaching a sample proj for your examination.

Have a look at the Tables & Quries as well

Thanks in advance...

[HiTechCoach]

I changed the =count([Member]![fName]) to be =1 and set the running sum to Over All and it counts the group headers. Is this what you want?

[Ignorant]

you got the solu. but a slight variation... Instead of Over all I reqd Over Group
one more followup (actually there are more but I'll open new thread for them)..

• There should be no s.no displayed if there is only one record in the group city
• How to add delimeter like ), . etc after the s.no.

[HiTechCoach]

you got the solu. but a slight variation... Instead of Over all I reqd Over Group
one more followup (actually there are more but I'll open new thread for them)..

• There should be no s.no displayed if there is only one record in the group city
• How to add delimeter like ), . etc after the s.no.

• How to add delimeter like ), . etc after the s.no.

I would use the Format property

[Ignorant]

something like & ")" in Format property..
I also noticed that simple & ) also works. Infact even if I put & ")" it gets converted to & ) .

now how about

• There should be no s.no displayed if there is only one record in the group city

[HiTechCoach]

In the format property for the text box with a control source of : =1 set the Format Property to: #)

See the attachenmnt in your other post.

[Ignorant]

See the attachenmnt in your other post.

you meant your attachment in #2 and not mine at #1 correct.

[Ignorant]

even adding #) works what's the diff between using &) and #)

[HiTechCoach]

It is two different methods to get the same end results. I have not really tried to figure out if one method is better.

[Ignorant]

There should be no s.no displayed if there is only one record in the group city

Now how to do this

[HiTechCoach]

I change the name the text box with the control source =1 to be txtCounter. I Added a text box named txtCount to the header with a control source of =Count(*) and set the visible property to no. Th in the On Format event use this:

Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
  Me.txtCounter.Visible = (Me.txtCount > 1)
End Sub

[Ignorant]

Thankz it works :thumb:
you have been very much helpful
by the way what's the meaning of this...

=Count(*)

if we translate this into pure code how should we put it.

[HiTechCoach]

What do you mean by pure code?