calculating within a form.

[lilbit27]

I have 15 questions on a form and for each question I have a combo box
where the user can pick five choices.

Strongly Agree
Agree
Neither
Disagree
Strongly Disagree


Each one carries a weight.

Strongly Agree = 5
Agree = 4
Neither 3
Disagree= 2
Strongly Disagree = 1


I am struggle as to how to pass the number that corresponds to the
text to main table or to a unbound text box so that I can get a
calculated total and give the user a Score.

Any suggestions. I can add a demo if needed.

 

[BruceM]

One option is to use a query that includes a number and text as the combo
box row source:

5 Strongly Agree
4 Agree
etc.

Bind the control to a number field, and for the combo box properties set the
bound column to 1, the column count to 2, and the column widths to something
like 0";1.5". Then it is just a matter of performing a sum on the number
field.

Another choice would be to use an option group, which would probably be an
easier interface for the users in that it would involve only clicking rather
than the two steps involved in making a combo box selection.

 

[KM Davison]

Each of the score fields within the table should be a number field with the
field size of byte.

Create a small table with 2 columns, the first is the score, the second the
text values you listed below, call this something like score lookup

on the form create combo boxes using the 2 columns in the score lookup
table, if you ensure the Control Wizard is on (looks like a magic wand) in
the toolbox, when you add the combo box to the form the wizard will appear
and you can do this easily. One of the choices in the wizard is to hide the
key field.

This way the column is the number, but you see the text, then you can create
charts and stats from this data.

Katherine Davison
Training Consultant