calculating simple percentages within a grouping- help!

[jackson5]

I have a report that is grouped by year. 2007, 2006, 2005. within each year
there are 4 ratings, and a count of those ratings. This table is linked to a
query that is doing a count of the ratings by year. I also have a footer
that sums the count of ratings, by year. What I'm trying to get is a
percentage of the ratings by year.

So in the example below, I'd like the percentage for Very Satisfied to be 33%
in 2007 (and 50% for 2006). This seems simple, but I have no clue how to
create the Percentage column. Any help would be greatly appreciated.


FYI It looks like this:

2007 Count Percentage
Very Satisfied 100
Satisfied 160
Somewhat Satisfied 75
Not Satisfied 65

Total responses: 300


2006

Very Satisfied 100
Satisfied 80
Somewhat Satisfied 10
Not Satisfied 10

Total responses: 200

 

[Steve]

Total responses for 2007 is 400 not 300 and Very Satisfied is 25% not 33%!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

 

[jackson5]

Good catch, this is a made up example. I still would appreciate help on
calculating percentages in a report. Thanks.

Total responses for 2007 is 400 not 300 and Very Satisfied is 25% not 33%!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I have a report that is grouped by year. 2007, 2006, 2005. within each year
there are 4 ratings, and a count of those ratings. This table is linked to

[quoted text clipped - 26 lines]

Total responses: 200

 

[Steve]

You could add another calculated field to your query that looks like:
Percentage:[Count}/DSum("[Count]","NameOfYourTable","[Year] = " &
[Year})*100

Note that Count and Year are both reserved words and should not be used for
field names. I do not know what your field names are.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

Good catch, this is a made up example. I still would appreciate help on
calculating percentages in a report. Thanks.

Total responses for 2007 is 400 not 300 and Very Satisfied is 25% not 33%!

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)

I have a report that is grouped by year. 2007, 2006, 2005. within each
year
there are 4 ratings, and a count of those ratings. This table is linked
to

[quoted text clipped - 26 lines]

Total responses: 200