hide total if only one record

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.
 
F

fredg

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
 

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

Report Group Footer DLookUp 0
A03 - count in report footer gives me #Error? 0
Group Totals and Grand Totals on each page 3
How to "copy" group running total to report footer? 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Count In Group Footer 1
Trouble with my sorting and grouping 4
Mail Merge skipping records/sending one at a time 0

Top