Hi all,
I am making a database for a local flower show (run by my Father in Law). I have made quite a lot of progress and a lot of the functionality. However I am now at the point where I need to transform the results of 1 - 4th place into scores and tallying them up.
Basically,
1st place = 5 points
2nd place = 3 points
3rd place = 1 point
4the place = 0.5 points
There are awards for different categories, some for best exhibit in class and others for most points in a section of classes. There is also prize money (small amounts) for these results.
Many people can enter many classes.
I need a way of tallying up these results in to a table and then calculating totals etc
Last year, we had a spreadsheet with each entrant across the top and each class down the side and just made a note of "5", "3", "1", or "0.5" and then used Excel formulas to calculate the totals and see who won which Award as a result of their scores.
However, in this database, I'd like to be able to store the scores in a table and then reference them on a form or a report to print out who gets what and keep it as a reference per year.
What would be the best approach of going about this?
I just need some pointers in the right direction.
Many thanks in advance,
Simon
I am making a database for a local flower show (run by my Father in Law). I have made quite a lot of progress and a lot of the functionality. However I am now at the point where I need to transform the results of 1 - 4th place into scores and tallying them up.
Basically,
1st place = 5 points
2nd place = 3 points
3rd place = 1 point
4the place = 0.5 points
There are awards for different categories, some for best exhibit in class and others for most points in a section of classes. There is also prize money (small amounts) for these results.
Many people can enter many classes.
I need a way of tallying up these results in to a table and then calculating totals etc
Last year, we had a spreadsheet with each entrant across the top and each class down the side and just made a note of "5", "3", "1", or "0.5" and then used Excel formulas to calculate the totals and see who won which Award as a result of their scores.
However, in this database, I'd like to be able to store the scores in a table and then reference them on a form or a report to print out who gets what and keep it as a reference per year.
What would be the best approach of going about this?
I just need some pointers in the right direction.
Many thanks in advance,
Simon