I am working on a report that calculates survey results. The data is normalized, with a query called "qryResults" that pulls together all the results based on numbers from various interrelated tables. My report displays the data based on headers
SurveyID Header - Identifies the survey being summarized
QuestionID Header - Identifies the question the data is coming from
AnswerID Header - Lists all the multiple-choice answers that were selected and how many times somone picked them
Detail - Lists any text comments surveyees made for the answer above
I want to count the uniques of the field CompletedSurveyID in the underlying query for the SurveyID listed in the header so that I can calculate the total number of surveys of a particular type and the percentage of a given answer in AnswerID. I realize that this could be accomplished in another header for CompletedSurveyID, but then the Answers get separated instead of being counted together.
How can I do this? Thanks for any assistance you can offer.
SurveyID Header - Identifies the survey being summarized
QuestionID Header - Identifies the question the data is coming from
AnswerID Header - Lists all the multiple-choice answers that were selected and how many times somone picked them
Detail - Lists any text comments surveyees made for the answer above
I want to count the uniques of the field CompletedSurveyID in the underlying query for the SurveyID listed in the header so that I can calculate the total number of surveys of a particular type and the percentage of a given answer in AnswerID. I realize that this could be accomplished in another header for CompletedSurveyID, but then the Answers get separated instead of being counted together.
How can I do this? Thanks for any assistance you can offer.
Last edited:
