Suppressing group total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to suppress the printing of a group total if the group conists
of a single record?
Thank you.
 
In the Group Footer section, put something like this into the Control Source
of your text box:
=IIf(Count("*")=1, Null, Sum([Amount]))

If you have a label that reads "Total:" and you need to suppress that label
as well, right-click it to Change To | Text Box, and set its Control Source
to:
=IIf([txtTotal] Is Null, Null, "Total:")

If you need more than that, you can suppress the entire section by setting
its Visible property in its Format event based on the value of Count("*").
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress total for first record of a group 1
Suppress individual Group Header Lines 4
Group Totals and Grand Totals on each page 3
ACCESS REPORT DEFINITION - Supress a Group on a Condition? 12
Suppressing undesired lines 1
suppress same information for the row 1
Suppress Blank Subreports 2
group suppression 3

Back
Top