How to get an Automatic Entry Based on Criteria

[Brewmeister]

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

 

[boblarson]

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","")))

 

[Brewmeister]

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.

 

[naveenharsha]

Dear Sir,
It did work tremendously, I hope this forum will definitely improve my ability and command over access
TQ
naveenharsha