learnaccesscg
Registered User.
- Local time
- Today, 07:13
- Joined
- Dec 1, 2014
- Messages
- 12
I am trying to have a field auto sum if specific values come up within a form. The form is a survey. Total all number zeros, total all 1's, 2's etc. so that I get a discrete value total for each option.
Ex.
Q1) 1 Q9) 0
Q2) 1 Q10) 1
Q3) 0 Q11) 2
Q4) 2
Q5) 1
Q6) 1
Q7) 3
Q8) 1
Total Number occurrences
Total 0's= 2
Total 1's= 6
Total 2's= 2
Total 3's= 1
Each question in the above example is a field within the same Form. Each total is its own field. Does anyone know if this can be done. and if so how?
Ex.
Q1) 1 Q9) 0
Q2) 1 Q10) 1
Q3) 0 Q11) 2
Q4) 2
Q5) 1
Q6) 1
Q7) 3
Q8) 1
Total Number occurrences
Total 0's= 2
Total 1's= 6
Total 2's= 2
Total 3's= 1
Each question in the above example is a field within the same Form. Each total is its own field. Does anyone know if this can be done. and if so how?