I created a databasr for results of a paper and pencil survey that was given to older adults. I created two tables, one table called lookup that houses all of the scales I used most important to least important 1-5 and Likert scale Strongly agree to strongly disagree) The other table actualy houses each one of the question Q1-Q20 answers). The form incorporates both tables. Once all 100 responses were entered I created queries for each of the questions. Useing the group by and count options.
Here is my issue, I need to create a reports for each individual question as well as a full report showing counts and percentages for each question and group of questions. A friend of mine told me to try and use a union query to bring everything together and then use that query for the report. How can I accomplish this?



Thanks