hiding totals in report

[chriske911]

is there another way then the iif (count of records < 1."".sum(fields)) in
every field to hide totals if there is just one record for any group

I want to give totals per group and then subtotals for the next level of
groups and then a grand total and then a gran grand total for the entire
report

needless to say there are many times the same amounts when there is just one
record in a group and this doesn't look very professional in the eyes of our
CEO

how to avoid this ?

thnx

 

[Allen Browne]

You want to hide a group footer section if there is only one record for the
group?

1. Add a text box to the Detail section, with these properties:
Control Source =1
Running Sum Over Group
Name txtCount
Format General Number
Visible No

2. Right-click the group footer section you wish to hide, and choose
Properties. Set the On Format propery to:
[Event Procedure]
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, paste:
Me.PrintSection = (Me.txtCount > 1)

The group footer section will now print only when there is more than one
record.

 

[chriske911]

unbelievably smart those mvp's, not only for one group but also for more
groups have I used your solution, as I mentioned I have subtotals, sum of
subtotals and sum of sum of subtotals
by counting each of these groups I now have a neat report to hand out

there is however still an empty space in place of the group, can I let this
disappear as well, but don't sweat over it, it's not that important,

thnx a million

You want to hide a group footer section if there is only one record for the
group?

1. Add a text box to the Detail section, with these properties:
Control Source =1
Running Sum Over Group
Name txtCount
Format General Number
Visible No

2. Right-click the group footer section you wish to hide, and choose
Properties. Set the On Format propery to:
[Event Procedure]
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, paste:
Me.PrintSection = (Me.txtCount > 1)

The group footer section will now print only when there is more than one
record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

is there another way then the iif (count of records < 1."".sum(fields)) in
every field to hide totals if there is just one record for any group

I want to give totals per group and then subtotals for the next level of
groups and then a grand total and then a gran grand total for the entire
report

needless to say there are many times the same amounts when there is just one
record in a group and this doesn't look very professional in the eyes of our
CEO

how to avoid this ?

 

[Allen Browne]

Could that be due to the top margin or page header section?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

unbelievably smart those mvp's, not only for one group but also for more
groups have I used your solution, as I mentioned I have subtotals, sum of
subtotals and sum of sum of subtotals
by counting each of these groups I now have a neat report to hand out

there is however still an empty space in place of the group, can I let this
disappear as well, but don't sweat over it, it's not that important,

thnx a million

You want to hide a group footer section if there is only one record for the
group?

1. Add a text box to the Detail section, with these properties:
Control Source =1
Running Sum Over Group
Name txtCount
Format General Number
Visible No

2. Right-click the group footer section you wish to hide, and choose
Properties. Set the On Format propery to:
[Event Procedure]
Access opens the code window.

3. Between the "Private Sub..." and "End Sub" lines, paste:
Me.PrintSection = (Me.txtCount > 1)

The group footer section will now print only when there is more than one
record.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to the newsgroup. (Email address has spurious "_SpamTrap")

is there another way then the iif (count of records <

1."".sum(fields))

in just
one of
our