Applying a Rating in A Form

[Lupson2011]

hi



I am trying to find a way of applying a rating based on particular values

Essentially, I have a scoring matrix which I have a calculation field at the end which totals the score.

however, what I need now is to apply a rating to this score with the following parameters

Excellent– score 6
Good – score 4 or 5
Satisfactory – score 2 or 3
Weak – score 0 or 1



So, if there is a total score of '4' in the Total Score text box, a rating of 'Good' will be shown in the appropriate feel. If there is a total of 6, ;'Excellent' will be displayed.


I know the long way round, but I know there will be some fairly straightforward code which I dont have a full graps on as of yet


Again, any help much appreciated


bagpuss

[alansidman]

Suggest you use Select Case functionality.

Here is a quick tutorial:

http://www.techonthenet.com/access/f...anced/case.php

Alan

[RuralGuy]

A User Defined Function (UDF) with a Case statement should do it.

[Lupson2011]

hi

Just a quick question, have created my case statement. Where do you put it behind, the Grade text box (which is where I want to display the appropriate grading). Is it an event procedure?

Sorry for ignorance on this

bagpuss

[Lupson2011]

Hi all

once again, thanks for pointing me in the right direction. I have place the case statement underneath each of the individual scoring combo boxes which make up the total score (in the after update). This has cracked it and I now have a functioning Grade text box

thanks

bagpus

[RuralGuy]

Glad we could help.