Percentage Based on adjacent Column

[jaslr]

Here's a sample of the query code for survey I made, for example
Question 1 will be
1) Male or Female?
(radio button answer_id 111) Male
(radio button answer_id 112) Female

etc etc...

My question is how do I set my query to show a graph / percentage value of total unique answer_id's in relation to the question_id.

e.g. Question 1: 66.67% chose 111, 33.3% chose 112

question_id	answer_id
1		111
1		111
1		112
2		116
2		117
3		119
3		121
4		126
4		126
4		126

I hope I was clear enough am quite new to Access and I really thought I could do this with pressing a few filter/sort buttons but alas I haven't found a way yet.

 

[The Stoat]

This might be of use.


The first query works out the individual counts of the results for each question i.e.for question 100 how many are A how many are B.

The second query Counts the total number of answers given for each question.


The third query works out the percentage by dividing query 1 by query 2.

The result column in query three is formatted for percentage - right mouse click on the fieldname in the column and select properties then select format.

HTH

TS