Access 2000 School Reports Database

[Guest]

I have a query that averages out the childrens' grades, but how can I get the
Report to automatically say "Commendation" when the Grade exceeds a certain
value? At the moment all I can do is set a conditional format that turn the
boc yellow if the field value exceeds the required level. Can I set a
condition on a field so that the word "Commendation" appears elsewhere on the
report?

 

[tina]

you can add an unbound textbox control to the report and set the control's
ControlSource property to

=IIf([GradeField] > x, "Commendation", Null)

replace "x" with the appropriate value, and substitute the correct name of
the grade field, of course.

hth