Calculations on Forms--Is this possible?

  • Thread starter Thread starter MartyM
  • Start date Start date
M

MartyM

I have a form where a user enters in a score of 0-4 for 20
questions. I then need to count how many answered scored
1 over the 20 questions and then another that scored 2
over the etire 20 questions. How do I get it so that it
automatically calculates on the form? Is this even
possible?

Thanks for any help.
 
I have a form where a user enters in a score of 0-4 for 20
questions. I then need to count how many answered scored
1 over the 20 questions and then another that scored 2
over the etire 20 questions. How do I get it so that it
automatically calculates on the form? Is this even
possible?
Click to expand...

It's possible, but we'll need a bit more information to say how. Are
these 20 questions 20 *fields* in a table, or (much better design) 20
*records*? You say "how many answered scored 1" - how many of the 20
questions, or how many people entered a score of 1, or what?
 
It is 20 fields called cansas_1 to cansas_20 (sorry about
the bad design. I am new at this). I basically have a
record for each client and what scores they answered for
each of the questions.

I need to know for each individual client, how many
answers out of the 20 questions did they rate a score of
1. I also need to count how many answers were a 2. Then
I have to add the count of #1 and the count of #2 to get
the client's final score.

Ironic that this is a test for severe mental illness. I
am going to rate high on this myself after this !! =)
Thanks for your help.
 
It is 20 fields called cansas_1 to cansas_20 (sorry about
the bad design. I am new at this). I basically have a
record for each client and what scores they answered for
each of the questions.

I need to know for each individual client, how many
answers out of the 20 questions did they rate a score of
1. I also need to count how many answers were a 2. Then
I have to add the count of #1 and the count of #2 to get
the client's final score.

Ironic that this is a test for severe mental illness. I
am going to rate high on this myself after this !! =)
Thanks for your help.
Click to expand...

Well, this calculation is considerably easier with the normalized
design but can be done with your "spreadsheet". In a vacant Field cell
in a query put the expression:

Score: IIF([cansas_1] <= 2, 1, 0) + IIF([cansas_2] <= 2, 1, 0) +
IIF([cansas_3] <= 2, 1, 0) + <etc. etc., you get the idea>)

This will calculate the entire score in one go; if you need the count
of 1's and the count of 2's also, use two more calculated fields with
=1 and =2 instead of using <= 2.
 
Back
Top