COunt Unique Values

  • Thread starter Thread starter Clay
  • Start date Start date
C

Clay

I am trying to create a report that will count the total disctint responses
for each question in a report. Here is what I have a set of 486 responses
with 40 questions. Each question has a reposinse of Yes, NO, NA or
Correction. I want to create a report to where I can summarize the count of
each response by question. Addionally I want to be able to group by
Department. Cna nayone help?

Here is what i have tried:
=Count(IIF(RhymeBOYK>3,1,Null))/Count(STUID)

and the DCOUnt
 
Syntax may not be perfect, because I have no way to test it, but it will give
you the idea:

SELECT [Dept], [Question], Count(IIf([Answer] = "Yes",[Answer],Null) As
Yess, Count(IIf([Answer] = "No",[Answer],Null) As Nos, Count(IIf([Answer] =
"NA",[Answer],Null) As NAs GROUP BY [Dept], [Question]
 
Back
Top