PT Tables

[Marcelino Benitez via AccessMonster.com]

I have a application for army pt program. I have an age field, pushup rep,
situps rep and 2-mile run-time. After enter the reps I wanna calculate how
many points they will have for each event. i have three dif tables. One -
Pushups, two- Situps and three - 2mile run
on each table I have age, rep and score. ie If i have a soldier that score 45
pushups, 50 situps and 1500 min run and 19 years he'll have 75 poinst for
Pushups, 76 points for situps and 80 points for the 2mile run. but first
need to be calculate by age. Thanks if you need more info let me know.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200510/1

[DFS]

Marcelino Benitez via AccessMonster.com wrote:

I have a application for army pt program. I have an age field, pushup
rep, situps rep and 2-mile run-time. After enter the reps I wanna
calculate how many points they will have for each event. i have
three dif tables. One - Pushups, two- Situps and three - 2mile run
on each table I have age, rep and score. ie If i have a soldier that
score 45 pushups, 50 situps and 1500 min run and 19 years he'll have
75 poinst for Pushups, 76 points for situps and 80 points for the
2mile run. but first need to be calculate by age. Thanks if you
need more info let me know.

Try a db structure more like this:

Exercise
------------
ExerciseID
ExerciseDesc

Soldier
-----------
SoldierID
Name
Age

ExerciseRepsPoints
-------------------
ExerciseID
AgeStart
AgeEnd
Reps
Points
SoldierExercise
------------------
SoldierID
ExerciseID
Date
Reps

[Bruce Rusk]

It might also be wise to put in a soldier's date of birth rather than age,
and calculate the age on the fly. Otherwise you'll have to update it every
time they have a birthday!

"DFS" <nospam@dfs_.com> wrote in message news:_r***************@fe06.lga...

Marcelino Benitez via AccessMonster.com wrote:

I have a application for army pt program. I have an age field, pushup
rep, situps rep and 2-mile run-time. After enter the reps I wanna
calculate how many points they will have for each event. i have
three dif tables. One - Pushups, two- Situps and three - 2mile run
on each table I have age, rep and score. ie If i have a soldier that
score 45 pushups, 50 situps and 1500 min run and 19 years he'll have
75 poinst for Pushups, 76 points for situps and 80 points for the
2mile run. but first need to be calculate by age. Thanks if you
need more info let me know.

Try a db structure more like this:

Exercise
------------
ExerciseID
ExerciseDesc

Soldier
-----------
SoldierID
Name
Age

ExerciseRepsPoints
-------------------
ExerciseID
AgeStart
AgeEnd
Reps
Points
SoldierExercise
------------------
SoldierID
ExerciseID
Date
Reps

[DFS]

Bruce Rusk wrote:

It might also be wise to put in a soldier's date of birth rather than
age, and calculate the age on the fly. Otherwise you'll have to
update it every time they have a birthday!
Yes. Good catch.


"DFS" <nospam@dfs_.com> wrote in message
news:_r***************@fe06.lga...

Marcelino Benitez via AccessMonster.com wrote:

I have a application for army pt program. I have an age field,
pushup rep, situps rep and 2-mile run-time. After enter the reps I
wanna calculate how many points they will have for each event. i
have three dif tables. One - Pushups, two- Situps and three -
2mile run on each table I have age, rep and score. ie If i have a
soldier that score 45 pushups, 50 situps and 1500 min run and 19
years he'll have 75 poinst for Pushups, 76 points for situps and 80
points for the 2mile run. but first need to be calculate by age.
Thanks if you need more info let me know.

Try a db structure more like this:

Exercise
------------
ExerciseID
ExerciseDesc

Soldier
-----------
SoldierID
Name
Age

ExerciseRepsPoints
-------------------
ExerciseID
AgeStart
AgeEnd
Reps
Points
SoldierExercise
------------------
SoldierID
ExerciseID
Date
Reps