No Subtotals when single records

  • Thread starter Thread starter Mervyn Thomas
  • Start date Start date
M

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
 
Mervyn said:
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?
Click to expand...

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)
 
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
 
Mervyn said:
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?
Click to expand...

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.
 
Back
Top