Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2012
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Access Report Counting Only Unique Values

    Hello
    I have a report which grouped like that: Classes>Subjects>Students .
    And I can easily count haw many students take Physics or Math.
    So Problem is how to count how many students in the class, because some students take physics and math (Report OverCounts number of student)
    I thought maybe I it is possible to count number of unique (distinct) StudentIDs.
    I would appreciate any help with this, Regards

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    You could introduce a field in the query defined as ClassCount and give it's value of 1.
    Then introduce a group footer for Class and put a sum of the ClassCount in there.

  3. #3
    New Lounger
    Join Date
    Sep 2012
    Posts
    8
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks, for reply. Can give more details? Because when I put ClassCount in Class Header then I am getting number of classes, instead of number of learners in that class
    Last edited by umarus; 2012-10-12 at 20:28.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    It would help to see your table structure,also what does your report look like?
    Last edited by patt; 2012-10-14 at 00:59.

  5. #5
    Star Lounger
    Join Date
    Mar 2011
    Posts
    52
    Thanks
    0
    Thanked 0 Times in 0 Posts
    showing your table and report structures will definitely help a lot.
    I am an Acess user and do things just fine so I may of help in anyway.

Posting Permissions

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