Solved: Solved:Merge string with int to make variable name

[lucky245]

Sorry, this is probably dead simple for you whizz kids but I've got a mental block on this for the moment.

I have 40 drop downs which are each call drp1, drp2 drp3 etc. (not my naming I hasten to add.) each holds a value depending on the answer Yes =1, No = 0 N/A = 2. These are then added together to get the total yes's (N/A are ignored by means of an if statement) At the moment the code reads


total = total + drp1
total = total + drp2
etc
etc
etc
total = total + drp40

All I'm trying to do is write a simple loop rather than leave it in the long list. Brain just wont function today.

Thanks in advance