In Access, How do I hide records, but include them in the total

[xeoimom]

I'm running a report where I have work orders. They are grouped by appr and
comp. I need to create a report that will show all the appr tickets, but
give me a total count of appr and comp. I have the report generated the way
I want, with total count, but how do i hide just the comp tickets.

 

[Marshall Barton]

I'm running a report where I have work orders. They are grouped by appr and
comp. I need to create a report that will show all the appr tickets, but
give me a total count of appr and comp. I have the report generated the way
I want, with total count, but how do i hide just the comp tickets.

You could use the group header section's Format event to
make the comp details invisible:

Me.Section(0).Visible = (Me.groupfield <> "Comp")

Alternatively, you can use the detail section's Format event
to cancel processing of the comp records:

Cancel = (Me.groupfield = "Comp")