How do I calculate percentages of each of 10 responses in a query

[taholmes160]

HI FOlks:



I have a table with 124 responses to a survey. One of the survey questions is How satisfied were you with the staff at the event. ( scale of 1 - 10)

So I have 124 responses with integer values between 1 and 10

that is the only column in the table under consideration in this query -- I can make it tell me what the possible values for the answers are, and how many of each, what I would like to put in a report is the %of total that each response got

Ive been digging around and have gotten a lot of random responses, but nothing that I can point to as the solution

Can someone please point me in the right direction.

Thanks
ITM

[ranman256]

make Q1 to count the totals of each value: select [Answer], Count(Answer) as AnsCt from table

make Q2 to count grand total: select Count(answer) as GrandTotal from table

make Q3 to get percent: select Q1.Answer , (Q1.AnsCt / Q2.GrandTotal ) as Pct from Q1, Q2

[taholmes160]

I have the Grand total working, im having issues with the query to count the totals

SELECT [Form Responses 1].SatStaffCOUNT [Form Responses 1].SatStaff
FROM [Form Responses 1]
AS AnsCT;

[Welshgasman]

You need spaces between the words?

[June7]

Need a space in front of COUNT and parens: COUNT(*). And probably need GROUP BY clause.

[Form Responses 1] is a table or query name? Strongly advise not to use spaces in naming convention.

You want to calculate percentage for each scale (1 - 10) value?

If you are building a report, can possibly do Count() and percentage calcs in textboxes without aggregate queries.

Example calc for 1 of 10 textboxes in report header or footer section: =Count(IIf([HowSatisfied]=1,1,Null))/Count(*)*100

If you need more help, provide sample data either as a table in post or attaching db file.