No Subtotals when single records

[Mervyn Thomas]

Can anyone tell me how to hide the group footer when there is only one
record in the group. I still want the grand total to be correct?. I
suppose this will be an event macro but I don't know how to get started?
Mervyn

 

[Marshall Barton]

Can anyone tell me how to hide the group footer when there is only one
record in the group. I still want the grand total to be correct?. I
suppose this will be an event macro but I don't know how to get started?

Add an invisible text box the detail section. Name it
txtLineCount, set its control source to =1 and RunningSum to
Over Group.

That add a line of code to the group footer's Format event
procedure:

Me.GroupFooterXX.Visible = (txtLineCount > 1)

 

[Mervyn Thomas]

Thanks that worked fine!!
I've used VB in Excell but need to get some good starting point experience
in Access for more of this type of event - where can you learn this stuff?
Mervyn

 

[Marshall Barton]

Thanks that worked fine!!
I've used VB in Excell but need to get some good starting point experience
in Access for more of this type of event - where can you learn this stuff?

Well, there's lots of ways to learn this stuff, depending on
how want to go about it. Trial and error, reading Help,
reading books and taking courses are the usual alternatives.
As a long time software development professional, I tend
towards the first two, but others prefer the more structured
approach of a How To book or a classroom.