Surveys

[Guest]

Okay, l have a survey that contain 28 quetions. Each question that is
answered yes, will have a number value to it. For example, if they answered
yes to "is the plan a 5500 plan?" that question is worth 1 point. I want the
total points added up on the form? So when I do a query and as for the plans
that scored between 50-60 ponts to pull up, it would be able to do so.

 

[Jeff Boyce]

Before you go any further, consider taking a look at an application created
by Duane H.:

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane

This may give you better ways to handle your survey and results.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Speaking from experience, if you are not already some sort of database
expert, that database will probably confuse you more than it'll help you.
If I may recommend some reading on database design for surveys, go here:

http://www.access-programmers.co.uk/forums/search.php?searchid=1029934

There are quite a number of threads on this, and I'm sure you'll find
something that'll help you.

Good luck

 

[Vinnie]

You can add a field in the table where the 5500 Plan is, and give it a
value.
If you are not using a table for the Options, you can do this by using the
LookupWizard to list the Answer choices, you can add another column to it,
listing the Value, but then Hide it from view. But in the query that pulls
the answers, you woulld add that value field to it, and then use the Sum
option. It will add all the instances based on the value you assigned.