|
One of my projects is based on golf scores. I am writing the scores to an access database for each hole for each person (36 people). I want to have a leaderboard which updates automatically the lowest 5 scores.
I can write my SQL statement to ORDER by TotalScore which will put them in the correct order. But....
I can't figure out a way to make TotalScore equal hole1 + hole2 + hole3 + .... automatically. I know in excel you can write code like =sum(a4:a9) and it will do that. Is there something like this for access?
|