Writing School Reports in Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm a schoolteacher collating end-of-term reports for our pupils using
Access 2003. Each teacher awards a grade for effort and one for achievement
on a 1 - 5 scale, and these are averaged out using a query. If a child
achieves an average grade of over 4.0 for effort they receive an "Effort
Commendation". For an "Achievement Commendation" they have to score over 4.5.
How can I add the word "Commended" on their report next to the box with the
average in it if they've reached this target? I can make the box with their
score in it change colour if they've achieved a Commendation, using
Conditional Format, but how can I make the condition met determine if the
word "Commended" appears in a DIFFERENT field, so I can include it on the
final Report?
I hope I've explained this properly!
 
Set the Control Source of this text box to something like this:
=IIf([AverageGrade] > 4.5, "Commended", Null)
 
Back
Top