AUTOMATIC OUTPUTS

T

Tim

Access 2000

In on of my tables I have a entry for a score [X:50]. The score corresponds
with a specific title:

X<35 = FAILED
34<X<45 = NOVICE
44<X<48 = INTERMEDIATE
X>47 = EXPERT

I currently have a seperate column in a table for the titles; is there a way
to set up a text box in a report with conditional formatting or someother way
to output the title based on the number ranges provided?
 
Top