Creating a sport event scoring form

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top