Recent content by Tr4c3yy

  1. T

    Count distinct

    HI I tried this but I have a Incorrect syntax near ')' on the first sum line which I cannot figure out
  2. T

    Count distinct

    Thank you for helping. when I use this code answers count the number of enrolments, not the number of unique learners.
  3. T

    Count distinct

    Thank you ! I tweaked yours a little and my totals are correct. SELECT count(distinct p.PERSON_CODE) Learners ,p.Sex Gender ,IIf(p.Primary_Disability = 91, 'With_Disability', IIf(p.Primary_Disability = 98,'No_Disibality', 'Other')) As Category Perfect answers I am just wondering...
  4. T

    Count distinct

    HI I am baffled and have tries all ways to count Distinct information. My database records learners and enrolments, and I need to count the unique number of learners for different categories, such as gender and Disability but SQL results are counting the number of enrolments. In this SQL the...
See more
Top Bottom