Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Group Totals

Discussion in 'Information Technology' started by Aaron Neunz, Oct 27, 2005.

Tags:
  1. Aaron Neunz

    Aaron Neunz
    Expand Collapse
    Guest

    I am designing an Access report. The control source for my report is a
    query with four columns of data.
    Two columns PRECNAME and PRECCODE may have duplicate records, all of which I
    need to appear on my report are doing so just fine.
    I have created an invisible text box with a control source =1 in the
    details section and another visible text box in my group footer section
    with the control source of that text box. However I only would like a count
    of the total number of DISTINCT records in each group. How can I accomplish
    this?
     
  2. Loading...


  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 26 Oct 2005 14:15:22 -0400, "Aaron Neunz" <apn@rrbiznet.com>
    wrote:

    >However I only would like a count
    >of the total number of DISTINCT records in each group. How can I accomplish
    >this?


    Set the Running Sum property of the textbox to "Over Group".

    John W. Vinson[MVP]
     
  4. Aaron Neunz

    Aaron Neunz
    Expand Collapse
    Guest

    I set that property, however my totals are still not distinct.

    Thanks
    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:c110m1p0k6crimrhl9v8fsi09qsac9tsme@4ax.com...
    > On Wed, 26 Oct 2005 14:15:22 -0400, "Aaron Neunz" <apn@rrbiznet.com>
    > wrote:
    >
    >>However I only would like a count
    >>of the total number of DISTINCT records in each group. How can I
    >>accomplish
    >>this?

    >
    > Set the Running Sum property of the textbox to "Over Group".
    >
    > John W. Vinson[MVP]
     
  5. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Mon, 31 Oct 2005 16:30:15 -0500, "Aaron Neunz" <apn@rrbiznet.com>
    wrote:

    >I set that property, however my totals are still not distinct.


    What's the Recordsource of the report? What do you have in its Sorting
    and Grouping? What are you seeing, and what do you want to see?

    John W. Vinson[MVP]
     
  6. Aaron Neunz

    Aaron Neunz
    Expand Collapse
    Guest

    The Recordsource of the report is a query consisting of four columns of
    data:
    USCONG, PRECCODE, SPLIT, & PRECNAME
    First I am grouping by USCONG which results in three groups on my report and
    is working correctly.
    I need to count the number of distinct PRECNAMEs (or PRECCODEs will work) in
    each group of USCONGs. On my report I am receiving 318.
    I should be seeing 274.
    I have an invisible text box named RecordCount in my detail section with a
    control source =1 and the running sum property set to Over Group. I have
    another text box with a Control Source =[RecordCount].



    "John Vinson" <jvinson@STOP_SPAM.WysardOfInfo.com> wrote in message
    news:fr2gm154o55cfmvc0ruihnb4g6qh2lslut@4ax.com...
    > On Mon, 31 Oct 2005 16:30:15 -0500, "Aaron Neunz" <apn@rrbiznet.com>
    > wrote:
    >
    >>I set that property, however my totals are still not distinct.

    >
    > What's the Recordsource of the report? What do you have in its Sorting
    > and Grouping? What are you seeing, and what do you want to see?
    >
    > John W. Vinson[MVP]
     

Share This Page