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.
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?
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
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.
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
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
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.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
It is two different methods to get the same end results. I have not really tried to figure out if one method is better.
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
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:
Code:
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
Me.txtCounter.Visible = (Me.txtCount > 1)
End Sub
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)
Boyd Trimmell aka HiTech Coach
Microsoft MVP - Access Expert
[SIGPIC][/SIGPIC] Office Programming 25+ years as a Software Developer specializing in:
Business Process Management
Accounting/Inventory Control
Customer Relations Management (CRM)
Electronic Data Interchange (EDI)