Show % of returned surveys

[icsupt via AccessMonster.com]

I have a report based off of a query. In the query, there are these fields:

NumberReturned
Lname
Ques1a
Ques1b
Ques2a
Ques2b
Ques3a
Ques3b
Etc...

I made Lname as a header and put [NumberReturned] in the header. The Ques
are in the detail section.

I would to calculate the % of NumberReturned. So for instance, if

NumberReturned = 10
5 people chose [Ques1a] (which when chose is “Orange”)
5 people chose [Ques1b] (which when chose is “Yellow”)

Then in my report, I want to show 1a = 50%; 1b = 50%.

1a 1b
1. Question 50% 50%

So here are my questions:

How do I count up how many surveys were returned and put that in
[NumberReturned]?

Then what is the formula for [Ques1a] divided by [NumberReturned]?

Thanks in advance for your help.

 

[Duane Hookom]

I would first normalize. Consider the demo "At Your Survey" at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.

If you can't change your structure, you could normalize your table with a
union query.

Are your fields Ques1a and Ques1b both possible answers for a single
question? Are they yes/no fields?