Scorecard Code

[andy_dyer]

Hi All,

I am attempting to create a form that will assign numeric values to the answers selected from combo boxes and then permit me to produce a total.

I've got 15 questions and depending on the answers selected in the combo boxes I want to allocate different scores...

I have tried several combinations of table and form structure, can anyone suggest an easy way forward for someone who doesn't know an awful lot of VBA?

Thanks

Andy

 

[andy_dyer]

I am trying to do this via a query...

This is the code I am trying to get to work so that if "Sometimes" is selected then a score of 5 is recorded.

Question1: IIf([Q1]="Sometimes",5,0)

In another database I've used this code to give a score of 1 is one field is greater than another.

PosDiff1: IIf([PreRHR]>[PostRHR],1,0)

I thought I may be able to do the same thing again?

Any help would be much appreciated...



Andy

 

[antomack]

Not sure if this is what you want but it might help you. It uses a table for each question's answers and allows you to set the values you want for each answer. At the bottom of the screen it will total the values of all the answers. It is in A97.

 

[andy_dyer]

Hi antomack!

Sorry for not sending my thanks earlier, I have been on my hols!

Thanks for that tho, it has worked a treat!!

Andy