Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Occurrence Counting (A2K)

    Iíve cruised the Forum first trying to find an occurrence of what Iím attempting and canít seem to find it.

    The goal is to count the number of occurrences of a number in Group Header 2. The report layout looks like this:

    GroupHeader1
    ProductNo

    GroupHeader2
    CNo

    Detail
    CNo Detail
    CNo Detail
    CNo Detail

    GroupFooter2
    Blank

    GroupFooter1
    This is where I want to count the number of CNoís that appear in GroupHeader2 for each ProductNo in GroupHeader1

    As always, Iíve tried a number of unsuccessful variations using the =Count([ ?? ]) combination in GroupFooter1, but the number always includes the number of lines in the Detail Section as well as the GroupHeader2 Section.

    Would appreciate any help on this,

    Cheers,
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Occurrence Counting (A2K)

    Put a text box in GroupFooter2 with the following properties:
    Visible: No
    Control Source: =1
    Running Sum: Over Groups
    Name: txtRunCount
    This text box is hidden, you can make it really small if you like.

    Put a text box in GroupFooter1 with the following properties:
    Control Source: =[txtRunCount]

    This text box will display the count you want.

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Occurrence Counting (A2K)

    Hans,

    Correct as always. Thank you.
    Cheers,
    Andy

Posting Permissions

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