|
StevieB -> identify results in results?? (10/2/2005 19:56:07)
|
FP02, access db, drw on spooky diet
I have a results page
http://websight101.com/EINT/PPA/results_page.asp
that makes a calculation in the Select statement...
fp_sQry="SELECT ID, PN, TRV, TVTO, VFSC, TVTO/TRV AS Turn_Out, VFSC/TVTO AS Support FROM PPA ORDER BY VFSC/TVTO Desc"
And I have no idea as to how to identify the results range.
For example: On the page listed above the highest result is 62 and the lowest result is 22. I need to define the range to do something like this...
(I'll be indebted forever for any help with code or defining HR, LR, R or x)
HR = High Result LR= Low Result R=Result
HR - LR * 100 / 3 = x
If (x*2 )+(LR*100) >= (HR*100)-x then response.write "H"
If x +(LR*100) =< (LR*100)+X then response.write "L"
Else response.write "M"
OR..
HR - LR * 100 / 3 = x
If (R *100)>= (x*2)+(LR) then response.write "H"
If (R*100)=<(x+LR) then response.write "L"
else
Note: I tried to use >= as greater than or equal to and =< as less than or equal to.
Boy I hope this makes some sense,
Thanks for any help!
Steve
|
|
|
|
