Hello everyone!
I'm having an issue I believe is simple to resolve, but I cannot seem to figure it out. What I want to do is analyze the data from different fields independently. I guess the easiest way to explain it is that it's like a survey. I want to know the percentages, average, group etc. for different fields. Ie.
Would generate a report such as:
Gender Happiness Favorite Color Education Age Range Male 2 Blue High school 25-30 Female 8 Green Post Grad 35-40 Male 9 Red None 10-15 Female 8 Blue High school 35-40 Male 7 Orange None 15-20
Gender
Male: 60%
Female: 40%
Happiness
Avg: 6.8
Education:
None: 2
High school: 2
Post Grad: 1
Age Range:
10-15: 1
15-20: 1
25-30: 1
35-40: 2
I know how to make a summary query for numeric fields, or group by to get the information above, but the problem is that there are many possible ways that I need to analyze (ie group by, average, count etc.) and I would need to run independent queries for each field which would be extremely slow. Is there anyway to make access (2007) look at the different fields independently? I am at a complete loss.
Thank you!