Summing text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a table, report & form with 40 questions, each questions has a
lookup field with 3 possible answers (satisfactory, unsatisfactory & not
applicable). I need to total how many times each employee used each answer.
Example: Total: Satisfactory (5) Unsatisfactory (3) Not Applicable (1).

Any help would be greatly appreciated
 
Tedy,
I use a very straight forward method... on the query behind the report,
add 3 columns like this one...
IsSat : IIF([Answer] = "Satisfactory",1,0)
Do the same for an IsUnSat field and an IsNA field.
Now, in your report/detail footer,
= "Satisfactory = " & Sum(IsSat)
would display the count of Satisfactory answers.
Do the same for IsUnSat and IsNA.

hth
Al Camp
 
I would expect the results to look like:
Total: Satisfactory (5) Unsatisfactory(4) Etc.
And I would want this at the bottom of the form and report. For example, I
took a look at your Employee Evaluation on Access. How would you total the
number of Very high, high or average ratings. Say at the bottom of the form &
report have a total for each rating. Then maybe take it a step further and
give another field to average those results to give a grade or percentage.
 
Don't you have 40 questions? Is the Total: Satisfactory(5) for one question
or all questions? A properly normalized table structure allows you to group
by a result value and count the number of responses.
 
The "Satisfactory (5)" is just an example of what I want. My mistake for not
being more clear. If I have 40 questions, then the results I want should look
like this: Satisfactory (10) Unsatisfactory (15) Not Applicable (15).
Applying that to your evaluation form, what would you use to calculate this?
Thank You.
 
A normalized table could use a crosstab to get this information. Did you
look at the survey application? Every single answer should be a record. Is
there any way you could change your structure? If not, you could try create
a union query that would normalize the records.
 
Back
Top