I have saved these in autocorrect; however, autocorrect is machine based coding. If I type "STBC" I get "search to be conducted", but no-one else using the database will.
I'm wondering is there a way to (ie how do you) program autocorrect functionality that is part of the database, rather than part of the user's Office settings
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I'm trying to create a report that returns the percentage of complete vs. incomplete responses:
Q YES NO NA
1 100% 0% 50%
2 50% 50% 0%
3 NA NA 100%
4 100% 0% 0%
5 NA NA 100%
I can't figure out how to make the report generate "NA" for the YES and NO fields on questions who's responses are NA (questions 3 & 5 above).
I need to show questions that are NA without those #VALUE! deals all over the place.
jpg (zipped since forum says new users can't post images) with the current relationship structure that I have. I have removed the Surveys table as there isn't a need formore than one survey any time soon.
Many of the survey questions are set up in sets like below (example only). Each question (Fruit 1-3) uses the same list of possible responses and the responses need to be ranked (Fruit 1= most preferred fruit, Fruit 3 = Least preferred).
List Your Top Three Fruits
Fruit 1: Apple
Fruit 2: Pear
Fruit 3: Orange
Because of this, I have set up an extra table with question categories. Otherwise, I would be storing a lot of redundant values if I had a table with only the QuestionID and PossibleResponses (some sets of questions will ask for as many as ten user responses that use the same set of possible responses)
I want to be able to join the Possible Responses table (SrvQPosResponses) to the table where the Survey Responses are stored (SrvResponses).
The At Your Survey database does not join these two. Don't I want to join them so that if I change a possible response, it will be updated in the survey responses as well (say if I want to rename Apple to Apples).
So, I want a query that outputs:
So far I've only built queries using Query Wizard (so SQL code still reads like Greek to me
At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next.
So in my case
if they answer
Q1 with yes they get Q2
if they answer
Q2 with Yes form does its normal thing
If they answer
Q1 with No they get Q3
If the answer
Q2 with no they get Q3
If they answer Q3 with Yes or No form does its normal thing!
I have tried numerous ways to sort these responses and am even confusing myself ! I have tried using the Elseif but to be honest Im not 100% sure I am using it right as depending where I put it in the order of the code it will work but the Questions then don't come up
The structure of the data is as follows:
Each respondent's survey is on a separate row
Each column contains the answer to a single question
All answers are constrained to a list of choices (e.g., Best, Bad, What I'd like to do is to build a report that shows the percentage of responses to each question. So, for example:
Question #1: What did you think of our product?
I was thinking something like a bar chart that would have the names of the questions along the x axis and a count of the responses along the y axis.
each question would have 4 bars one for each of the answers (strongly disagree, disagree, agree and disagree). the aim would be to allowmanagement to see where the strong points and weak points across the board.
Model ; SN; Date ; Windows; Tires; Interior
Ford; 1234; 1/1/2011; Good ; Good; Fair
Ford; 1234; 1/1/2012; Good ; Poor; Poor
Chevy;9000; 1/3/2012; Fair ; Good; Fair
Toyota;5555;1/3/2012; Good; Poor; Good
and turn it to a crosstab type output that groups the responses of conditions to resemble the following:
.Windows; Tires; Interior
Fair ; 1 ; 0 ; 2
I did many calculations with these including counting them individually and getting the percent for each one based on the over all count. Now I would like to create a bar chart with the four responses listed that will update each time it's run.
I created the chart but have to type in the figures for each response myself. Since the calculations are done on the report and not in the query is there a way to use the fields from the report. Unfortunately, this is my first time trying to use the Chart feature in Access. If I can't do this with the Chart option is there another way to have a bar appear on a report?