Cross Tab Query Summing

[paulcherianc]

Hi Experts!

I am trying to do some sum of percentages through my cross tab query and couldn't get through:banghead:

Could anyone help me to resolve it.

Please look into my screen shots.

1. in the first picture you may see the query.
2. is the result of that query.
3. is the one I need.

Please help!

 

[arnelgp]

you should modify the original query where this query is derived.

 

[paulcherianc]

Thanks Arnel! As you know i am not proficient in programming! Could you please try to see and fix the original query in the attached file if possible

 

[arnelgp]

i hope i get it right. i made a query to total all percentage (qryTotal).
then made a new query Query1 based on qryTotal.

see Query1.