I'm havimg an database table with 10 users (ID) who play golf. They insert there score everytime they play using the ID, which means that there can be several of records with ID=1 and so on. I'm then getting the average of all there scores depending on the ID using a line like this.
strSQL = "SELECT AVG(brutto) as brt from Score WHERE ID=1"
So far so good. Now i would like to get the 3 best averages to be displayd. How the hell do i do that?
I have little golfclub with a leaderboard where each member gets point after each match (1 - 20 points). Is it possible to get the average point of the last 10 records, and what if they only played 7 matches can i get the average of that.
View Replies View RelatedIs i t possible to get data into a list/menu from a specific field in a db table like "date"?
View Replies View RelatedIve got an accces database with a couple of table in it at the moment but this will grow to 5 tables pretty soon then maybe more after that.
I would like to be able to populate a drop down menu with all the table names in the database any ideas how to do this or if its even possible.