Perform calculations in a form with possible null fields

  • Thread starter Thread starter KevinS
  • Start date Start date
K

KevinS

I have a form that has has three questions with a answer value of 0 - 5. I
need to get the total of the responses from the three questions and then get
an average.

Caveat! Not all the questions will be answered so some questions will be
blank. This does not affect the total but it WILL affect the average.

Any suggestions?
Thank you!
 
How is the data stored?
Is there a record for each question?
Do you record who is responding and when?
 
Data is in a number format 0 decimals.
each question is a field - not a separate record
Do not track name or time.

Thank you,
Kevin
 
Post table and field names with datatype.
YourTableName --
Quest_1 - Number
Quest_2 - Number
Quest_3 - Number

Post sample data.
Quest_1 Quest_2 Quest_3
4 3 0
3 1 4
5 5 2
 
Back
Top