code

[bpaquette]

hrm... so i have something i want to write but am afraid i'm having trouble figuring out where to start. recently my squadron did a physical fitness test of running, pushups, situps, and abdomen measurement. the results of each gave you a point score based on age/gender. so for me, a 19 year old male, 65 pushups gave me 10 points. what i would like to do is write up a db to store scores, and automatically calculate peoples scores based on data entered. the problem is i have no idea where to begin. there isn't a formula relating any stats to the score they result in, so it looks like i'll just have to write a crapload of code covering all the possible scores, but that's as far as my limited coding knowledge will bring me.

is there anyone who's ever done anything like this; or would have an idea where to start?

 

[namliam]

an idea is to create a table....
tblScores
Type____AgeRangeStart_AgeRangeEnd_NumberStart_NumberEnd_Score
PushUps_20___________30__________50_________59_________9
PushUps_20___________30__________60_________200_______10
SitUps___20___________30__________100________149________9
SitUps___20___________30__________150________200_______10

You can the query the results, plus results are then flexible (adaptable by the user) whereas if you code it, its not...

Hope that gives you some idea

Regards