Comments for individual records

[direptor]

Hi,

I have created a query to calculate an average score of a list of attribute used to grade a list people and from this average score, i need to give them a rating.

Is there any way for me to give each individual a different grading either using a dropdown list or manually keying in the rating on a form base on the average score calculated? Eg i would want a good grade for someone who score between 3 to 4, average for scores between 2 to 3 and poor for scores below 2.

Currently when i use a text box in a form, whatever i typed for 1 entry is copied to the rest but what i need is a different entry for each individual person's record.

Thanks.

 

[Trevor G]

What sort of Form are you using is it just a single record you view then do your calculation?

You could use an After Update Event from a control that fills another using a little VBA with an IF Statement or Case Statement.

 

[direptor]

What sort of Form are you using is it just a single record you view then do your calculation?

You could use an After Update Event from a control that fills another using a little VBA with an IF Statement or Case Statement.

All the calculations are done already in a query. I just need to use a form or any other method to fill up rating base on that score which can then be printed on a report with all the results and rating.

Sorry quite a noob with Access so totally clueless about SQL or VBA stuff...

 

[Trevor G]

Create an EXPRESSION in the query which will add the text you want it would use an IIF Statement.

Expr1: IIf([Score1]<2,"Poor",IIf([Score1]<3,"Average",IIf([Score1]>=3,"Good","")))

 

[direptor]

That works. Thanks alot and it saves the effort required to manually enter each rating

 

[Trevor G]

Your welcome and thanks for letting me know.