Generating report -
05-22-2004
, 07:10 PM
To all Guru's
I have the below listed query in access, it works fine, but I need to
display the same results by months.
SELECT SurveyResults.Q2, SatisfactionIndex.SatisfactionType,
Count(SatisfactionIndex.SatisfactionType) AS CntST
FROM SatisfactionIndex INNER JOIN SurveyResults ON
SatisfactionIndex.SatisfactionNumber = SurveyResults.Q2
GROUP BY SurveyResults.Q2, SatisfactionIndex.SatisfactionType
ORDER BY Count(SatisfactionIndex.SatisfactionType) DESC;
Any help would appreciated!
Thanks |