I'm trying to create a subcontractor evaluation database.

There are several items which will be rated, i.e.:
1. Quality of workmanship
2. Ability to meet schedule
3. Expedite and coordinate work with other trades
etc.
Each one of these would have a "rating" field.

At first I thought I'd just make a form and have these qualifiers as labels. Then I thought that I'd like to at some point create a query basically saying "show me all subcontractors who scored 3 and above for Quality of workmanship.

So, I thought I would have to create a table, (i.e. Quality table) with the fields, Quality of Work, Subcontractor ID, Rating. I then thought I would have to make the Quality of Work field inaccessible by the user. So, of course when I create the form and tell it to pull in that field, it (of course) pulls in the label part as well as the field part. I think I want to somehow hide the field part. Is this possible?

Do you think I'm tackling this in the correct manner?

Thanks for any help you can offer.

But I'm a little confused nonetheless.

Are your subcontractors rated once, and modified as needed? Or are they rated on every job and the Average used as their rating? If the latter case is true, do you want to show all subcontractors that ever got a 3 or higher, or only have had 3 or higher, or averaged 3 or higher?

My suggestion is to look into a Totals Query if you're rating them more than once. You can Group By SubcontractorID, and Avg the Ratings in each category to get a average score. (or Max if you want the highest rating ever, or Min for the lowest rating ever).
Now create another query based on this totals query, and that is where you set the >=3 criteria.
It won't work in the first one because it'll apply the criteria before it Averages, so you'll have skewed results. (if your subcontractor scored 1,1,1,1,3,5, they'll have a 4 average instead of 2).

Hopefully that helps. I've I've misunderstood or confused, post back.

P.S. If you don't know this already, rating them more than once will require a One-to-Many relationship between your Subcontractors table and your Ratings table.