hide total if only one record

  • Thread starter Thread starter kristeven
  • Start date Start date
K

kristeven

In an Access report, I don't want the total, in the group footer, to appear
if there is only one record for the group.
 
In an Access report, I don't want the total, in the group footer, to appear
if there is only one record for the group.
Click to expand...

Add an unbound control to the detail section.
Set it's control source to:
=1
Set it's RunningSum property to Over Group.
Name this control "CountGroup"
You can make this control Not Visible.

Code the Group Footer Format event:

If you have no other control's to show in the Group Footer:

Cancel = [CountGroup] = 1

If you do want the Group Footer to show but just not the Total
control, then use:
Me.[TotalControl].Visible = Not [CountGroup] = 1
 
You must log in or register to reply here.

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

A03 - count in report footer gives me #Error? 0
Count In Group Footer 1
How to "copy" group running total to report footer? 3
Trouble with my sorting and grouping 2
Count or sum unique records in a report's group footer in Access 2 2
Group Totals and Grand Totals on each page 3
Group Footer Summarizing Problem 5
Calculating percentage from grouped report 3

Back
Top