Reports - scoring

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

I am in the middle stages of planning a database and one
report i would like is to give a score to our
subcontractors. Either a Good, Average or Poor rating.
Say for example, if a subcontractor was to score 90%
ontime then they would recieve a Good rating. I want this
to print out automatic on the report.

Any help would be great.
 
On a report i want the computer to give a rating. So if
they scored 90% on time, then they would get a Good rating
but if they scored 15% on time then they would receive a
Poor Rating. I did not know if this could be done in a
query or if a macro would have to be written???
 
Do you have a table that equates a score with a rating? This would have max
score, min score, and rating fields.
 
Back
Top