When using the Crosstab Query Wizard to count values, is it possible for
either the Query or Report (made from the query) to also display the
percentages that sum to the total column? Here's an example of what I'm
looking for:

TOTAL CATEGORY1 CATEGORY2
4 (100%) 3(75%) 1(25%)

Yes. Edit the source of the value. If the currect source is Quality and
the Total is the Sum([Quality]) then use this in the grid --
[Quality] & " ( " & [Quanity]/Sum([Quanity])*100 & " )"

--
KARL DEWEY
Build a little - Test a little


"Cheese" wrote:

> When using the Crosstab Query Wizard to count values, is it possible for
> either the Query or Report (made from the query) to also display the
> percentages that sum to the total column? Here's an example of what I'm
> looking for:
>
> TOTAL CATEGORY1 CATEGORY2
> 4 (100%) 3(75%) 1(25%)