Percents

  • Thread starter Thread starter anthony.carter
  • Start date Start date
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
 
Can you share more significant information such as your table structure or
report's record source? How about some sample records?
 
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
 
Back
Top