Report Survey is not working properly. Please HELP!!

S

Suzanne Wyatt

I have done something wrong somewhere I want to be able to have percentage
of yes to no responses per 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])
I get the wrong percentage.
I want ex. Question 1: Responses Count
Yes 3
No 2
Total Responses 5
Percentage of Yes 60%
Can I do this? How would I do it? Please help.
The underlying SQL Follows:

SELECT tblClientResponse.SurveyQuestionID,
qselreportsurvey.SurveyQuestionNumber, qselreportsurvey.SurveyQuestion,
tblClientResponse.SurveyResponseID, tblSurveyResponse.SurveyResponse,
Count(tblSurveyResponse.SurveyResponse) AS CountOfSurveyResponse
FROM tblSurveyResponse INNER JOIN (qselreportsurvey INNER JOIN (tblSurvey
RIGHT JOIN tblClientResponse ON tblSurvey.SurveyID =
tblClientResponse.SurveyID) ON qselreportsurvey.SurveyQuestionID =
tblClientResponse.SurveyQuestionID) ON tblSurveyResponse.SurveyResponseID =
tblClientResponse.SurveyResponseID
GROUP BY tblClientResponse.SurveyQuestionID,
qselreportsurvey.SurveyQuestionNumber, qselreportsurvey.SurveyQuestion,
tblClientResponse.SurveyResponseID, tblSurveyResponse.SurveyResponse;
What should I change, I can't get this to work. I could really use some
help. TIA..Suzanne Wyatt
 
F

Fons Ponsioen

If you create a report and group it by the
[SurveyQuestionID], than create a footer for this
grouping, you may place the corresponding controls in the
applicable footer and they should calculate correcly.

Hope this helps
-----Original Message-----
I have done something wrong somewhere I want to be able to have percentage
of yes to no responses per 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])
I get the wrong percentage.
I want ex. Question 1: Responses Count
Yes 3
No 2
Total Responses 5
Percentage of Yes 60%
Can I do this? How would I do it? Please help.
The underlying SQL Follows:

SELECT tblClientResponse.SurveyQuestionID,
qselreportsurvey.SurveyQuestionNumber, qselreportsurvey.SurveyQuestion,
tblClientResponse.SurveyResponseID,
Click to expand...
tblSurveyResponse.SurveyResponse,
Count(tblSurveyResponse.SurveyResponse) AS CountOfSurveyResponse
FROM tblSurveyResponse INNER JOIN (qselreportsurvey INNER JOIN (tblSurvey
RIGHT JOIN tblClientResponse ON tblSurvey.SurveyID =
tblClientResponse.SurveyID) ON
Click to expand...
qselreportsurvey.SurveyQuestionID =
tblClientResponse.SurveyQuestionID) ON
Click to expand...
tblSurveyResponse.SurveyResponseID =
 
S

Suzanne Wyatt

I've tried this didn't work.
Fons Ponsioen said:
If you create a report and group it by the
[SurveyQuestionID], than create a footer for this
grouping, you may place the corresponding controls in the
applicable footer and they should calculate correcly.

Hope this helps
-----Original Message-----
I have done something wrong somewhere I want to be able to have percentage
of yes to no responses per 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])
I get the wrong percentage.
I want ex. Question 1: Responses Count
Yes 3
No 2
Total Responses 5
Percentage of Yes 60%
Can I do this? How would I do it? Please help.
The underlying SQL Follows:

SELECT tblClientResponse.SurveyQuestionID,
qselreportsurvey.SurveyQuestionNumber, qselreportsurvey.SurveyQuestion,
tblClientResponse.SurveyResponseID,
Click to expand...
tblSurveyResponse.SurveyResponse,
Count(tblSurveyResponse.SurveyResponse) AS CountOfSurveyResponse
FROM tblSurveyResponse INNER JOIN (qselreportsurvey INNER JOIN (tblSurvey
RIGHT JOIN tblClientResponse ON tblSurvey.SurveyID =
tblClientResponse.SurveyID) ON
Click to expand...
qselreportsurvey.SurveyQuestionID =
tblClientResponse.SurveyQuestionID) ON
Click to expand...
tblSurveyResponse.SurveyResponseID =
tblClientResponse.SurveyResponseID
GROUP BY tblClientResponse.SurveyQuestionID,
qselreportsurvey.SurveyQuestionNumber, qselreportsurvey.SurveyQuestion,
tblSurveyResponse.SurveyResponse;
What should I change, I can't get this to work. I could really use some
help. TIA..Suzanne Wyatt


.
Click to expand...
Click to expand...
 
Top