I have to figure out how to get working in my application.
Here is the original forumula
round(if(r - (n * 0.3) < 0.51, 20 * (sqrt(sqrt(n) * n / r)) + 20, 20))
the value for "R" will be taken from this same record from a field called, "finish_position"
the "N" needs to come from a different table called, "events" field name "attendance"
I'm thinking that I first need to do a DLookup to assign the attendance to a variable.
I tried to just replace the N and R with the field names but it was giving me an error.Code:varAtt = DLookup ("attendance","events", "event_id=" & event_id)
As I'm writing this, I think I might be able to break it up and put it into an "if then"Compile Error:
Expected: Expression