monthly evaluation set up

[Jay]

I am in the process of building a data base that pulls data from one column
in one table and compares it against columns in another table in order to
come up with a rating. For example in table1 (we will call tblMonthlyReviews)
in one column we will call Quality. A person scores a 76% in Quality and you
want to look at the Quality Table to see if this person falls within a
certain percentage to meet a rating of a 3 or 4. How would I set this up. I
have racked my brain and can not figure it out.

 

[Duane Hookom]

It isn't clear what your current setup is. I don't know what you mean by
"compares it against columns in another table". This sounds a bit like a
spreadsheet.

You might want to look at the Employee Evaluations sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. This
solution is quite flexible and normalized.

 

[Bryan]

I would build a query that looks up the values on your form that you want to
compare. Use the "<", ">", and "=" to filter the values returned. Then link
your field to that query. Here is the formula I used.
<=(DLookUp("Mec","ApplicantTbl","SSN=[Forms]![ApplicantMainOuterForm]![ApplicantMainForm]![SSN]"))
This looks up the the Mec score in the applicant table, using the unique Id
of the Social Security Number of the person selected in my form. I can send
you a sample if you want. I will have to clear it of socials and names.
(e-mail address removed)