Hi,
I am trying to create a report on Access for surveys tallying up multiple choice questions. But I need to perform additional limits restraining them to the last 100 survey IDs because we continuely add surveys and report on changes.
Example:
Q1 A=12 B=3 C=2 D=0
Q2 A=12 B=3 C=2 D=3
Q3 A=11 B=2 C=1 D=4
Created 4 Unbound Text Boxes on your Report, with their Control Sources set to the following:
= DCount("*", "tblSurvey", "[Reply] = 'A'")..........'for Reply A
= DCount("*", "tblSurvey", "[Reply] = 'B'")..........'for Reply B
= DCount("*", "tblSurvey", "[Reply] = 'C'")..........'for Reply C
= DCount("*", "tblSurvey", "[Reply] = 'D'")..........'for Reply D
Is it possible to include further limits/criteria such as SurveyID = 1-99