translating values into categories

  • Thread starter Thread starter John
  • Start date Start date
J

John

can anyone help me with the following?

i have a report set up that will generate a score for a
particular section of survey for all entires (i.e.
61/100).

What i'd like to be able to do is to assign each section
a rating based on that score (either poor, fair, or
good). How do I get access to display such a score for a
report???

Thanks!!
 
John,

Depends a bit on how and where the score is being arrived at. But as
a general principle, one way would be to use a calculated control,
using an expression based on the score. Possibly the IIf() function
or the Switch() function would be the most likely approaches. For
example...
=IIf([Score]<50/100,"poor",IIf([Score]<75/100,"fair","good"))

- Steve Schapel, Microsoft Access MVP
 
Back
Top