CODEWITHSUNDEEP
vbams-access
user2395238
user2395238

Reputation: 900

How to count number of records in a section in ms-access report?

On my report I have sections that are summarized at the bottom. Some of the sections have only one record though. In that case, I don't want to show the Total. So, basically, I am looking for something like my code below (which doesn't work because RecordCount is not Sections property). Any solutions?

Private Sub prv_subtotal_Format(Cancel As Integer, FormatCount As Integer)

If Me.Section("prv_subtotal").RecordCount = 1 Then Cancel = True

End Sub

Upvotes: 0

Views: 1799

Answers (1)

AVG
AVG

Reputation: 1462

Put a hidden textbox in the detail section and set the controlsource to =1 and RunningSum to OverGroup. Then change your code to Cancel = (me!hiddentextbox = 1)

Upvotes: 2

Related Questions