Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS ACCESS






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Calculate Percentages Of Survey Responses?


I'm setting up a database for student evaluations. Students have several options as to how well the instructor did for each survey question. I've been able to set up the data entry form to my liking, and I can use a query to average the total answers to each question, including a count of how many people responded. HOWEVER, I need to calculate the percentage of responses for each option. For example, I need to know the percentage of students who picked "Excellent" for question 1, how many students chose "Very Good", how many chose "Good", etc., so on and so on for every question. How can I do that? I'm completely stuck and a novice user. HELP!!:eek:


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SURVEY Database - Problem On "survey Questions"
Hi, I have a survey database file containing the following tables

tblQuestions - contains survey questions
tblResponse - contains responses inputted by user
tblRespondents - contains info on user (e.g. Name, Add...etc)

Is it possible that answer to some questions are dependent on other questions?
for example:
Question 1 -True/false
Question 2 -True/false

Question 3 -True/false

If question1=false or question2=false then question3=false
(the response to question 3 is automatic and dependent on the responses of question1 and question2)

Thanks in advance for those who can give me some suggestions.

View Replies !   View Related
Questions And Responses Tables
I have a table with questions and a table with responses. The questions are all answered with Yes, No, or Don't know. However, two of the questions go on to say that if you answered yes, please specify. It then provides a list of possible specifications for the "yes". One of the possible specifications is "other". I need to know how to set up an additional table for the question/statement: If you answered yes, please specify. I then would need a table for its responses. Same goes for the option "other", I need a table for the responses for other. Attached is my paper form that I am devising my questions from. It is in part iii of the app. Question 6 and Question 11 are the questions I do not know how to deal with. I also don't know how to set the overall section up. Since each question will have a yes/no/don't know, but how do you set it up when you get to Q6 and Q11 to have it ask the user additional questions or ask for more information?

Attached is also my DB. You can view tblApplicantQuestions and tblApplicantResponses to see what I have set up so far in line of questions and responses.

View Replies !   View Related
Questions And Responses Tables
I have a table with questions and a table with responses. The questions are all answered with Yes, No, or Don't know. However, two of the questions go on to say that if you answered yes, please specify. It then provides a list of possible specifications for the "yes". One of the possible specifications is "other". I need to know how to set up an additional table for the question/statement: If you answered yes, please specify. I then would need a table for its responses. Same goes for the option "other", I need a table for the responses for other. Each question will have a yes/no/don't know, but Question6 and Quesiton 11 has additional questions or ask the user for more info. how do you set it up when you get to Q6 and Q11 to have it ask the user additional questions or ask for more information?

Attached is also my DB. You can view tblApplicantQuestions and tblApplicantResponses to see what I have set up so far in line of questions and responses.

View Replies !   View Related
Counting The Responses In A Report
I have a database for collecting evaluation responses for training. There are 20 questions, with a combo box for each with responses: agree, strongly agree, neutral, disagree, strongly disagree, n/a. I want to create a report that counts the number of responses for each question from a session. I don't know how to put a calculation field in a report to count the various responses and am not a programmer. Can someone help me.

Thanks.

View Replies !   View Related
Parameter Query W/null Responses W/date Range
I have set up a parameter query with multiple criterias. I have also set it up so the query will accept a null response from the user. I have done this by using the following string in the criteria section:

[rma?] Or Like [rma?] Is null

This works fine except how do I apply this theory to a date range in the criteria? This is what I tried but it does not work properly:

Between [Begin Date?] Or Like [Begin Date?] Is null And [End Date?] Or Like [End Date?] Is Null

Any suggestions of how to make this work and return the proper data if the search dates are not entered?

Appreciate any help!
B&R

View Replies !   View Related
Percentages
Simple question: how do you convert vlaues into percentages?
I have a boolean expression so when it's ticked the bookings are regular, and if they're false they are occasional bookings. I have used 10 bookings as test data (5 regular - true, 5 occasional - false). How would I convert these into percentages? For example, I've used the "Count" total to fint the number of regular and occasional booknigs, which are both 5. This is 50%, but how would I do that? Thanks for your help guys. :)

View Replies !   View Related
Percentages Help :)
hey there i need help :)

ok, so i have to work out week by week percentage uses
i have a query that already finds the bookings in the week already, that works fine, but then i need to find the % use for that week, which is the count of the number of bookings in the week / 21
ive tried doing this in an update query, but it doesnt like me :)
any help would be great :)
i have a % use field in my table that it updates to, but im flexible :)
thanks

View Replies !   View Related
Percentages Of Time
Hello all,

I have a requirement to give a % figure from 2 time fields. I would have thought this was simple, but when I divide the fields I keep getting #Error. Its not an error caused by a divide by zero, i can recify those. Can anyone point me in the right direction to get a % from 2 time fields.

Cheers
vmed

View Replies !   View Related
Displaying Percentages
This is probably simple but it's something I haven't had to do before.

I have a main table.
I have a filter query based on this table.
I have a report, based on the query, which displays the total number of records in the query.
In the same report, I would like to display this total as a number (already done, obviously) and also as a percentage of the total number of records in the main table.

How would I go about this?

View Replies !   View Related
Query Percentages
Hey guys.
I have a boolean expression which I want to calculate the percentage of.
I have the field 'Regular Booking' which is either true or false. I have 6 true and 5 false, equalling to 11 in total. I've tried using: 100*[CountOfRegular Booking] / [TotalRegular Booking] but this gives me the same percentage for both true and false. So if I enter 5 I get 45.54% for both true and false... why is this? I've had trouble with this for ages now and I'm pulling my hair out, lol. :(
Thanks guys!

View Replies !   View Related
Percentages In Option Groups
Been searching for an answer to this one but still cant quite get it.

I am using an option group to subtract and add percentages on an amount in a text box. This is the code i am using but there is something wrong. My syntax is out.

Me.TechsRate = ((Me.Chargeout.Text - (Me.Option17.OptionValue /100))

I am trying to calculate 5% or 10% or 15% and so on, up to 35%

Thank you in advance

View Replies !   View Related
Data Type For Percentages Or Text?
Is there a data type that I can use that will handle both text and numbers such as percentages? Or is there a way I can set the field type to text then convert the text to a percentage? I plan on using this field in a form so when the user inputs the info I will want to display it in the correct format. Any ideas or suggestions?

Thanks

View Replies !   View Related
Crosstab Query & Calculating Percentages
I'm trying to compare referred clients of different racial/ethnic backgrounds based on whether my agency accepts, defers, or denies their cases. Here are the tables and fields involved involved:

TblReferralMaster:
ReferralID (PK)
RaceID* (FK)
DecisionID (FK)

TblRace:
RaceID (PK)
Racecategories

TblDecision:
DecisionID (PK)
decisionname

Here are the queries I've made to allow me to do a crosstab query that reports the numbers of referrals in each category:

Racextab1:
SELECT TblReferralMaster.referralID, TblRace.Racecategories, TblDecision.decisionname
FROM TblRace INNER JOIN (TblReferralMaster INNER JOIN TblDecision ON TblReferralMaster.DecisionID = TblDecision.DecisionID) ON TblRace.RaceID = TblReferralMaster.[RaceID*];

Race-decxtab:
TRANSFORM Count(racextab1.referralID) AS CountOfreferralID
SELECT racextab1.decisionname
FROM racextab1
GROUP BY racextab1.decisionname
ORDER BY racextab1.decisionname, racextab1.Racecategories
PIVOT racextab1.Racecategories;

How to I make a second crosstab where the row headings are decision names, the column headings are race categories, and the values are percentages (number of clients of a given race where a given decision was made / all clients of that race where any decision was made)? I found some other threads on the forum related to crosstab queries and percentages, but either those problems weren't quite the same as mine or my limited SQL isn't enough for me to figure out how to apply those solutions.

Thanks!

View Replies !   View Related
Percentages In Table Design View
can anyone explain how to use a percentage in a table.

i have a field designated as data type "number" and format set to Percentage.

when i go to datasheet view and attempt to enter in these percentage (1%,50%, 34%, etc) it is multiplying the data entered by 100 (100.00%,5000.00%,3400.00%, etc).

gotta be something easy.

TUKTUK

View Replies !   View Related
Simple Query Problem - Calculating Percentages
Hi, first post!

Just started doing access at work and have a problem.

I have a database. Each record has a bunch of different fields.

In one field, the record can either be DC or DS (different classifications).

I would like to run a query which would tell me the percentage of DCs and DSs.

I have managed to create a query that counts the total of each one, but for the life of me i cannot figure out how to do the percentages.

Can anyone help?

I am using Access 2000 and my query is being made in design view

The Query has 2 columns:

Column 1
Field: DC/DS
Table: Main
Total: Group By
Show: yes

Column 2
Field: DC/DS
Table: Main
Total: Count
Show: Yes


Can I add the percentage section as another column (using an expression?) or will it have to be another query, that runs the above query then uses data from that?

Thanks, Craig

View Replies !   View Related
Survey Db
I've been asked to make a survey db by someone. I was wondering what is the best way to go about this? The output spread sheet list several questions asked of the user. The user id and questions asked are in columns. So you could have a columns like the user id: date: when was the last time you reaed a book?:Did you like the book?: Was the book helpful? What type of book was it?. These are listed in many rows one for each survey asked. Is my best bet to just make each column a field name in a table and build off of that? Some of the question asked are very length? I can have the spread sheet altered to column names that are more relivant and shorted so when I import into access and populate them into a table it will be easier to follow. Just looking for a little guidance. All thoughts are appreciated. Thanks...

View Replies !   View Related
Survey With Many Users With Log-ins Please Help
I need to create a database that allows users to log in. Once logged in they choose 1 of 3 locations. Then they choose a department. They get a different set of questions based only on the department. Each store has the same set of questions.

Thanks for your help. Let me know if I need any other info.

Would you give me some help, If I told you its has nothing to do with Best Buy.

Please help.

View Replies !   View Related
Another Question On A Survey Database
Ok, I need further help with that my survey database. I wonder if somebody could help me figure this out. So, I have this survey database with questions for visitors of a certain park. I have several Yes or No questions. I created queries that will count how many Yeses or Nos I have for each question. But a problem is happening. Sometimes certain questions are left blank, with no answer. My query is showing the blank answers with a count of zero, even if there are more then one blank answers. How can I get the query to count the blanks? Or, can I fill the blank answers with the word "Blank" automatically somehow?

Thanks

View Replies !   View Related
Survey Database Design...
I am trying to set up a database that manages responses to a variety of survey questionaires, and I want to know if I am on the right track before I proceed. Sorry if this gets a bit verbose:

Here's the general 'business rules':

1) There are many different historic survey types. Some have also not yet been defined.

2) A specific question may appear on more than one survey type.

3) Each survey type can have a different number of questions.

4) The 'valid' answers to a survey question fall into two general groupings:
- multiple choice (variable number of choices)
- freeform text (and "other__________ " could be a multiple choice response)

5) There will be a lot of repetition in the multiple-choice choices. For example, there will be lots of "TRUE/FALSE" or "YES/NO" questions, lots of 'Rate the following on a scale of 1 to 5' type questions, etc.

6) Some of the multiple choice valid-answer-sets may be more unique, such as '200,400,600,1000,other'.

7) We (sometimes) want to capture such information as 'don't know', or 'answer illegible' or 'not answered' or 'don't care', but these can just be more 'pre-set' choices in the db that do not appear on the paper forms

After some whiteboarding, I arrived at the attached db structure....

View Replies !   View Related
Survey - Check All That Apply
I will have the following tables:

tblSurvey
tblQuestions
tblAnswers
tblResponses
QuestionID -PK
SurveyTakerID - PK
Response

You get the idea - a normalized table.

Anyway for questions that state "check all that apply" I could either store in the Response Field a yes, or a no (or a number code for those answers) OR simply store the yes values for ones that are checked. Seems like the latter, but for querying later, will I run into problems? I have had different views based on reviewing posts.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved