R
Robert Riley
Hi, this has me stumped.
I have a table with the following fields;
autonumber, name, rank, event1 result, event1 score, event2 result,
event2 score, (six events in all).
I have a form to enter the event results. Three events are timed events,
(the ones I am having trouble with scoring) the other three are distance
and number of type events. The scoring is 1=100, 2=90, 3=80, 4=70,
5=60, all the rest score 50 points.
I figure for when each timed event is entered, I need to do the following;
1 Get current rank from form displayed
2 Get current event name for the result just entered
3 Check to see if all of rank in #1 have the event in #2 entered.
4 If all entered, do the scoring (if-then-if-then...???)
So my question is how to go about doing all of this?, is this what needs
to be done and is it the right order?
If you haven't guessed, I am very new to Access.
Hope this is not to much to ask.
I have some reports that I could print and then enter the score into the
database manually, but I would like to do this all based off of the
event(s) results being entered.
Rob
I have a table with the following fields;
autonumber, name, rank, event1 result, event1 score, event2 result,
event2 score, (six events in all).
I have a form to enter the event results. Three events are timed events,
(the ones I am having trouble with scoring) the other three are distance
and number of type events. The scoring is 1=100, 2=90, 3=80, 4=70,
5=60, all the rest score 50 points.
I figure for when each timed event is entered, I need to do the following;
1 Get current rank from form displayed
2 Get current event name for the result just entered
3 Check to see if all of rank in #1 have the event in #2 entered.
4 If all entered, do the scoring (if-then-if-then...???)
So my question is how to go about doing all of this?, is this what needs
to be done and is it the right order?
If you haven't guessed, I am very new to Access.
Hope this is not to much to ask.
I have some reports that I could print and then enter the score into the
database manually, but I would like to do this all based off of the
event(s) results being entered.
Rob