Percents

A

anthony.carter

Hi,

In a report is it possible to have more than one 'percent'
calculation?

I have a simple table with scores in it ranging from 0 to 4. I have
queries which give a count of how many 4's there are, 3's there are
etc.

Now I can just about get a simple single % calculation in a report,
but would it mess things up if the same report attempted to show the
percentages for each score?

Cheers

Tony Carter
 
D

Duane Hookom

Can you share more significant information such as your table structure or
report's record source? How about some sample records?
 
E

Eric Blitzer

if your scores are stored in the same field
Create a query with 4 fields in it
Count1s: Sum(IIf([Score]=1,1,0))
Count2s: Sum(IIf([Score]=2,1,0))
Count3s: Sum(IIf([Score]=3,1,0))
Count4s: Sum(IIf([Score]=4,1,0))

Use these field names for your percentage calculations in your report
 
Top