monthly evaluation set up

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top