% of specific response in crosstab report

[Slow1911s]

Here's my crosstab report

Answer Name1 Name2 Name3

Yes 90 95 85

No 10 10 35

Total 100 105 120


I need to devide the number of Yes responses for Name1 by the total number of responses. I tried doing it like this =(([Name1]=Yes)/sum([Name1])), but that isn't working.

Thanks in advance,

Dave

eta - this post is duplicated in the queries forum because I wasn't sure if it was a report or a query issue.

 

[stopher]

Why not arrange your crosstab so that the names are the rows and the Yes/No are the columns.

Answer__Yes__No
Name1___90__10
Name2___95__10
Name3___85__35

Then a writing a second query based on your cross-tab query to calculate your % becomes rather straight forward.
hth
Stopher