Select, Calculate, and Analyse

[escoyne]

Ok, here's another one I need help with. This may be a little lengthy to explain but here it goes.

Ok, I have five items that have specific values applied to each of them.
A = 10 pts
B = 5 pts
C = 35 pts
D = 25 pts
E = 5 pts

I need to be able to select with items apply, (one or all) and be able to calculate the values (pts) of each item selected. Then take the points and apply them to different levels..i.e:
Level 1 == 0 to 20 pts
Level 2 == 21 to 34 pts
Level 3 == 35 or more pts

Now, with all that, where do I begin to make this work?

Jason

 

[gemma-the-husky]

where are trhe items stored - in the record?

have a function

evaluate_score(a as boolean, b as boolean, etc) as long
dim score as long

score=0

if a then score=score+10
if a then score=score+5
etc

evaluate_score=score
end function

----------
in your query have a column that says

myscore: evaluate_function(aflag,bflag,cflag,dflag,eflag)

that will give you a sortable/testbale total

eg in the critera row put >=30 to filter the column

 

[escoyne]

I dont have them stored anywheres.

This is what I need done and have no idea where to begin or end.