Radio Button Value

[WLMPilot]

I have minimal knowledge on radio buttons. I am designing a QA table and
form to be used to grade reports at work using 1 - 5. I want the Supervisors
to grade each question by choosing a radio button 1 - 5. I will add the
numbers up in a report for viewing.

My question is how can I calculate the total without using an IF statement
to see which button was chosen?

Thanks,
Les

 

[ghetto_banjo]

On the form, create an Option Group for each question, and assign the
values 1-5 for each label. Then you can just add up the values via
the Option Groups and not use any if statements.

 

[Jeff Boyce]

I'm not sure I'm visualizing your data setup yet...

Are you saying that you are using separate fields for each question/item to
be rated? If so, that sounds very much like ... a spreadsheet!

Access is a relational database, though, and to get the best use of its
features/functions, you need to feed it well-normalized data.

It all starts with the data ... and you seem to be describing a form (i.e.,
"radio buttons" are controls on a form).

More info, please... (let us know what data/structure you are working
with...)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[John W. Vinson]

I have minimal knowledge on radio buttons. I am designing a QA table and
form to be used to grade reports at work using 1 - 5. I want the Supervisors
to grade each question by choosing a radio button 1 - 5. I will add the
numbers up in a report for viewing.

My question is how can I calculate the total without using an IF statement
to see which button was chosen?

Thanks,
Les

An option button simply stores a number in the table. You're not adding up
option buttons! You're adding up DATA from the table.

The Option Group control has multiple option buttons (or checkboxes or
whatever visual appearance you prefer); each has an assigned numeric value.
When the button is clicked that value is stored in the Option Group's control
source field in the table. The Report would not need to even know how the data
were put into the table - it can just add up the 1s, 4s and 5s stored in the
table.

 

[Daryl S]

Les -

Each group of 5 radio buttons should belong to an option group. One group
per question. The value of the option group (and of the bound field) will be
based on the radio button selected within that group. You can just sum the
fields (once stored in a table), or sum the values of the option groups. You
must make sure when you set up the option groups and the radio buttons within
each option group that the value of the button matches your choices for
rating 1-5. Look up help on the option groups.

 

[WLMPilot]

Thanks for your help. That is what I needed to know.

Les

 

[WLMPilot]

Thanks for your help. That is what I needed to know.

Les

 

[WLMPilot]

Thanks for your help. That is what I needed to know.

Les

 

[Guest]

I have minimal knowledge on radio buttons. I am designing a QA table and
form to be used to grade reports at work using 1 - 5. I want the
Supervisors
to grade each question by choosing a radio button 1 - 5. I will add the
numbers up in a report for viewing.

My question is how can I calculate the total without using an IF statement
to see which button was chosen?

Thanks,
Les