How can I stop printing a particular line of totals in an Access 2007 Report?
If you have only one “line”, putting a “Total” underneath is unnecessary (and looks ridiculous). Like this:
John Smith £100.00 £40.00 £60.00
Totals £100.00 £40.00 £60.00
In GroupFooter3, for example, I have “totals” like (=Sum([xyz1]) and an invisible control (=[txtcontrol]) where txtcontrol = the number of “lines” added up in each total.
In GroupFooter3_Format(Cancel… my code is <if Me.txtcounter.value=1 then Reports(“Main_Report”).PrintSection=False> should work (I think) but doesn’t!
Where have I gone wrong?
Help would be very much appreciated. Thank you.