Calculating Averages

[stu_gnu]

Hi
I'm currently working on a database of which the main question centres around whether a person has used a certain product or not, with the response being either Yes or No.
I have managed to create a query which counts how many people said yes and how many said no. However I've been unsuccessful in creating a calculated field which works out the percentage of people who said yes and who said no.
Any ideas? many thanks

Stu.

 

[jujuluver]

I beleive you will have to add a calulation that divides number of yes answers by the total number of responses then the number of no answers by the total number of responses. This should give you a percentage of each answer. Hope this helps!

Alan