Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Thanked 0 Times in 0 Posts

    Reports Groupings (Access 2002)

    I have a report that groups on types; I subtotal on types. I like to eliminate the subtotaling when certain types have only one record because it appears that the report is duplicating lines.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Reports Groupings (Access 2002)

    I assume you have a group footer. Put a text box with control source =Count(*) in this footer, you can set its Visible property to No if you don't want it to be displayed. Let's say the text box is named txtCount.
    Put the following code in the On Format event of the group footer:

    Private Sub GroupFooter1_Format(Cancel As Integer, FormatCount As Integer)
    Cancel = (Me.txtCount = 1)
    End Sub

    (GroupFooter1 is the name of the group footer)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts