My database tracks individuals qualifications. These qualifying scores relate to Unqualified, Expert, Advanced etc. What I want to do is add a entry into my roster table which will have the qualification score.
I then want to have the score and actual qualification (Advanced, Expert, etc) in a Report.
The qualification type is a range (less then 30, 31-40, 41-50), and I think that I will need a BETWEEN statement. What I am not sure of is how to put this together to make it equate the number with the equivalent word in a report.

Thanks
the brewmeister

The qualification type is a range (less then 30, 31-40, 41-50)

Put an unbound control on the report and set it's recordsource to:

=IIf([YourFieldNameHere]<30,"Beginner",IIf([YourFieldNameHere]>30 And [YourFieldNameHere]<41,"Advanced",IIf([YourFieldNameHere]>40, "Expert","")))

Bob
Thanks
That did the trick. I will play with this since I also need to have different qualification scores related to different types of qualifications (in a separate table). If I can't figure it out myself, I will ask for more help.