
1. Re: Calculating Formulas
mrvodka Mar 19, 2010 1:19 PM (in response to spinny)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.

2. Re: Calculating Formulas
spinny Mar 19, 2010 9:20 PM (in response to spinny)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.
Thanks
Andy

3. Re: Calculating Formulas
comment_1 Mar 19, 2010 9:39 PM (in response to spinny)Your GPA table can look like this:
GPA Points
3.2 63
3.3 64
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