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

How to "copy" group running total to report footer? 3
Suppress total for first record of a group 1
A03 - count in report footer gives me #Error? 0
Group Footer Summarizing Problem 5
Count In Group Footer 1
Report Footer 1
Using MoveLayout to print subtotal on last detail line of group 2
Total not correct in Footer 1

Top