B
Bernie
Putting together a database to record Student-Teacher
evaluations, several tables, etc. Each student's
completed evaluation is one record, related to the course
table by an ID number; each student then given autonumber
(anonymous evaluations). Primary key in the student
response table is a double, courseID and ResponseID (the
autonumber). Then, a field for each question. These
responses entered in subform created from this table (or a
query if need be). I can easily code summation fields in
the footer of the subform, then replicate in the main
form, and put on a report, such as Avg, StDev, etc.
However, I need frequencies!!! Most questions have
responses of values 1 to 7 (they're all numbered response
values). I need to show, in the form and on the report,
the frequencies of the values of each response to each
question, as well as the summary stats. I have found two
possible ways, but don't know if I can translate them onto
the form and/or report. One way is to set up a query for
each question, with say, Q1 as the first field (where the
responses would be entered), and Group By in the Totals
row, then set up, say, FreqQ1 as the second field, with
Count in the Totals Row. This creates a query counting
the values for each response in the Q1 field, which is
what I need. I'd have to do this for each question (oh
well). However, how show the entire query results in the
form and/or report? If I create another query, using the
original responses table and all the 27 new question
queries, how can I show the full results of the question
queries (the frequencies of responses) in the form, will
they show? Do I need to put this in the subform footer,
and set equal fields in the main form, or can I just put
them on the main form, with the queries added to the
Select Query on which the main form is based? The other
solution is similar, but even more queries. I would set
the first field in a query, calling the field Count(*),
then setting the second field as Q1, with the criteria for
each value (such as 1). Thus, I'd have to have a new
query for EACH POSSIBLE RESPONSE FOR EACH QUESTION.
Roughly 120 queries to do this. Drag, why can't they set
a frequency function as easily as in Excel???? I've
tried, but haven't yet found any Frequency function in
Access.
Bernie
evaluations, several tables, etc. Each student's
completed evaluation is one record, related to the course
table by an ID number; each student then given autonumber
(anonymous evaluations). Primary key in the student
response table is a double, courseID and ResponseID (the
autonumber). Then, a field for each question. These
responses entered in subform created from this table (or a
query if need be). I can easily code summation fields in
the footer of the subform, then replicate in the main
form, and put on a report, such as Avg, StDev, etc.
However, I need frequencies!!! Most questions have
responses of values 1 to 7 (they're all numbered response
values). I need to show, in the form and on the report,
the frequencies of the values of each response to each
question, as well as the summary stats. I have found two
possible ways, but don't know if I can translate them onto
the form and/or report. One way is to set up a query for
each question, with say, Q1 as the first field (where the
responses would be entered), and Group By in the Totals
row, then set up, say, FreqQ1 as the second field, with
Count in the Totals Row. This creates a query counting
the values for each response in the Q1 field, which is
what I need. I'd have to do this for each question (oh
well). However, how show the entire query results in the
form and/or report? If I create another query, using the
original responses table and all the 27 new question
queries, how can I show the full results of the question
queries (the frequencies of responses) in the form, will
they show? Do I need to put this in the subform footer,
and set equal fields in the main form, or can I just put
them on the main form, with the queries added to the
Select Query on which the main form is based? The other
solution is similar, but even more queries. I would set
the first field in a query, calling the field Count(*),
then setting the second field as Q1, with the criteria for
each value (such as 1). Thus, I'd have to have a new
query for EACH POSSIBLE RESPONSE FOR EACH QUESTION.
Roughly 120 queries to do this. Drag, why can't they set
a frequency function as easily as in Excel???? I've
tried, but haven't yet found any Frequency function in
Access.
Bernie