[AccessD] how to count selected combos in a form

Kostas Konstantinidis kost36 at otenet.gr
Thu Nov 2 08:39:05 CDT 2017


Dear people,

I am a little confused about how to count part of included compo box into a form...
I'll try to explain it better.
So, into a form I use 22 compo box (titled from SRS1 to SRS22) with 5 options for each one of them or null if unanswered.
These 22 combos are divided into 5 different groups
As the final result depends on the selected values of each separated group what I need is on current form to count how many questions have been answered for each group

The groups are 
1st group: SRS5, SRS9, SRS12, SRS15 and SRS18 and I need to count how many of them have been answered...
2nd group: SRS1, SRS2, SRS8, SRS11 and SRS17 
3rd group: SRS4, SRS6, SRS10, SRS14 and SRS19
4th group: SRS3, SRS7, SRS13, SRS16 and SRS20
5th group: SRS21 and SRS22

Have you any idea about how to count this?
Thank's

/kostas






More information about the AccessD mailing list