 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / November 2005MS Access reports
Hi, I am trying to create a crosstab type of report without using crosstab query. The report captures several survey questions and for each survey questions there are multiple choices that users responded to. Basically I am trying to create a report that will look some thing like this displaying question text, multiple reponse text and the response rate: Text for Question 1 Agree Disagree Strongly Agree 70% 20% 10% Text for Question 2 Good Poor Don't know 30% 20% 50% Text for Question 3 Satisfied Notsatisfied 20% 30% I can not create a crosstab query as each question has different answers choices to select from which result in having a total of more than 70 answer choices. Any help will be appreciated. Could you share your table structure? I'm not sure how you expect us to help you without understanding your data.  SignatureDuane Hookom MS Access MVP -- > Hi, > [quoted text clipped - 18 lines] > than 70 answer choices. > Any help will be appreciated. Hi, There are three tables for this particular report that are being used. LkupQuestion has all the questions, LkupAnswerChoices has all the anwerChoices. The third table contains the association of questions and anwer choices with the response rate. The third table looks like this which is pulling the report. QuestionID Answer ChoiceID Response 1 1 50% 1 2 30% 2 3 20% 2 4 10% and so on. Thanks There are several sample crosstab reports at http://www.invisibleinc.com/divFiles.cfm?divDivID=4. The crosstab.mdb has a report where the column headings might differ. SignatureDuane Hookom MS Access MVP -- > Hi, > There are three tables for this particular report that are being used. [quoted text clipped - 11 lines] > and so on. > Thanks Thanks ever so much!! It saved me a lot of time figuring out how to generate a report like this. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.