In your table GPACALC, create records for each grade range and correpsonding points. You should have a lower, upper, and points fields.
Then create a relationship from your main table to this table where:
GPA ≥ lower
GPA ≤ upper
Noe you can either put the points field directly on the layout or if indeed you want a lookup to put into another field, then your lookup based on this relationship should work.
Ok.... got it working. There is a small problem though. I dont want to have 180+ values in my gpa table. Is there anyway for it to look at ranges - right now if I put in 3.2 for a gpa it finds the value that corresponds with that and returns the number of points. If I input 3.26 as a gpa it returns nothing. You get 63 points for a gpa between 3.2 & 3.29, 64 points for between 3.3 & 3.39 and so on. I need it to recognize that any number between 3.2 and 3.29 gets the same score.
Your GPA table can look like this:
and the relationship can be:
YourTable::GPA = GPA::GPA
Then set the lookup to copy next lower value if no exact match.
BTW, if the pattern is constant you could simply calculate the points as =
Int ( GPA * 10 ) + 31