Surveys Artismae 29.09.2006 18:57:02 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.

Re: Surveys "Jeff Boyce" <nonsense[ at ]nonsense.com> 29.09.2006 19:24:16 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 "Artismae" <Artismae[ at ]discussions.microsoft.com> wrote in message news:9102597B-1CEF-49E0-BC34-4B95D8A45C4C[ at ]microsoft.com... [Quoted Text] > 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.

Re: Surveys Niniel 29.09.2006 19:40:03 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 "Jeff Boyce" wrote: [Quoted Text] > 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 > > > "Artismae" <Artismae[ at ]discussions.microsoft.com> wrote in message > news:9102597B-1CEF-49E0-BC34-4B95D8A45C4C[ at ]microsoft.com... > > 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. > > >

Re: Surveys "Vinnie" <vinootz[ at ]comcast.net> 30.09.2006 16:27:39 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. "Artismae" <Artismae[ at ]discussions.microsoft.com> wrote in message news:9102597B-1CEF-49E0-BC34-4B95D8A45C4C[ at ]microsoft.com... [Quoted Text] > 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.