Summary for text field

  • Thread starter Thread starter Desiree Haubner
  • Start date Start date
D

Desiree Haubner

I have a simple Database that was designed to track the
responces to a recent survey that was sent to all
employees. In one table I have all the questions asked
and the other table I have the avaliable answers. There
are over 80 questions. I am trying to design a summary
report that will basically tell me How many people answer
Question 1 Strongly Agree, Agree, Etc.

I am new to this and I tried the expression builder but I
keep getting errors. Any help would be greatly
appreciated.....
 
Depending on how you are collecting/entering the
responsesyou could do a count for condition,
or possibly a summary query.
This will depend on the actual structure of your tables.
Give some more information if this does not help.
Merry Christmas.
Fons
 
I have been trying a count expression but I keep getting
syntax errors = Count («expr») «Expr» [questions]![Job
Satisfaction 1] = strongly agree. And = Count
(«expr») «Expr» [questions]![Job Satisfaction 1] =
[answers]![Strongly Agree] are examples. I only have to
two tables set up.
 
Okay let me assume that you have a field called "response"
which has one of the following three
entries "disagree", "agree" and "strongly agree"
in this case you can have a variable in a query or in the
report which would be:
=Sum(Abs([response]="agree"))
this would yeald the total count of th response which
said "agree"

and similarly for the others.
Hope this helps.
Merry Christmas.
Fons
-----Original Message-----
I have been trying a count expression but I keep getting
syntax errors = Count («expr») «Expr» [questions]![Job
Satisfaction 1] = strongly agree. And = Count
(«expr») «Expr» [questions]![Job Satisfaction 1] =
[answers]![Strongly Agree] are examples. I only have to
two tables set up.
-----Original Message-----
Depending on how you are collecting/entering the
responsesyou could do a count for condition,
or possibly a summary query.
This will depend on the actual structure of your tables.
Give some more information if this does not help.
Merry Christmas.
Fons
.
Click to expand...
.
Click to expand...
 
You only have 2 tables? Then you need at least 2 more.

Answers would have the possible answers available

Agree, Disagree, Strongly Agree etc. with a number (it can be an autonumber)

If they are the same for each question then that makes it much easier.

You then only need an Employee table - if the answers are anonymous then it
need only contain a number for each survey sheet.

Append the ID fields of Employee and of Questions to your third table,
EmployeeAnswers by putting the two tables, unjoined, into the query grid so
that all the questions are added to each Empoyee. This field will have a
third field, a number field, where you can record the ID number of the
answer using a combo box in your form.

You can now make a Totals Query which will contain only the answers
and questions from EmployeeAnswers and which will Count how many people
answered with each
answer (add the answer field twice,once to view it and once to count it).
You can base your report on this query.

Evi
I have been trying a count expression but I keep getting
syntax errors = Count («expr») «Expr» [questions]![Job
Satisfaction 1] = strongly agree. And = Count
(«expr») «Expr» [questions]![Job Satisfaction 1] =
[answers]![Strongly Agree] are examples. I only have to
two tables set up.
 
Back
Top