Form: Ranking responses scale 1-10

[Sunny]

I need to add a question to one of my forms where the responses are ranked
from 1-10. Any ideas on the best way to set this up?

In the end, I need to be able to compile the results either in a graph or
percentage of responses.

Thank you for the help!

 

[John W. Vinson]

I need to add a question to one of my forms where the responses are ranked
from 1-10. Any ideas on the best way to set this up?

In the end, I need to be able to compile the results either in a graph or
percentage of responses.

Thank you for the help!

First off... you do NOT want to store the data in a form. A form is *just a
window*, a tool to let you edit data stored in tables. You'll need a table
with an integer number field in which to store the ranking.

For an example of a properly normalized questionnaire database see Duane
Hookum's "At Your Survey":
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='At Your Survey 2000'

and/ro

Roger Carlson's Training Registration database:
http://www.rogersaccesslibrary.com/download3.asp?SampleName=TrainingRegistration.mdb

 

[Sunny]

Thank you for taking the time to respond.

Although I'm fairly new to Access and to this discussion group, I have
worked with databases, tables, SQL etc.

You taught me a valuable lesson... I should have been more explicit when
drafting my question.

The links you sent were very informative. I have my work cut out for me

Regards,
Sunny