Help with report for survey summary.

S

Suzanne Wyatt

My counts are not working properly. I want it to sum percentages by number of yes/no, etc. responses to each question, not as a percentage of all responses.
Here is what I have, how do I change it and where should I place it?
In Survey QuesionID footer:
="Summary for " & "'SurveyQuestionID' = " & " " & [SurveyQuestionID] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"
Sum:
=Sum([CountOfSurveyResponseID])
Percent:
=Sum([CountOfSurveyResponseID])/([CountOfSurveyResponseID Grand Total Sum])
In the Report Footer:
Grand Total:
=Sum([CountOfSurveyResponseID])
TIA Suzanne Wyatt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Survey is not working properly. Please HELP!! 2
A03 - count in report footer gives me #Error? 0
getting an average on the "Count" in a report summary 2
Running Sum 13
SynNeed to account for null values in subreports 2
Summing in a Report Footer 7
Calculating overtime in report footer 2
Calculations in reports 2

Top