N
Nordman - the Polar Ice Man
I've made a create table query for a temporary results where I want to ad
rankings.
I've tried many times, but all I could manage to print was Ranking with the
total value of records in every field of my listing.
I can modify the table by deleteing the prior and making a new maually, but
I wish to update the records with a command routine or a macro after I've
entered the results in random order to the tmp-table.
Table contents:
[tTmpResults]
[PlayerID], [TournamentNr],[BtoScore],[Total] (Desc)
Values: 17, 10, 555, 690
1, 10, 525, 645
10, 10, 525, 585
11, 10, 520, 582
I wish to add Tournament ranking as I have another table where the ranking
points are for each position, but I cannot update the Order of Merit, since
there is no linking fields between the order of the records at the moment.
rankings.
I've tried many times, but all I could manage to print was Ranking with the
total value of records in every field of my listing.
I can modify the table by deleteing the prior and making a new maually, but
I wish to update the records with a command routine or a macro after I've
entered the results in random order to the tmp-table.
Table contents:
[tTmpResults]
[PlayerID], [TournamentNr],[BtoScore],[Total] (Desc)
Values: 17, 10, 555, 690
1, 10, 525, 645
10, 10, 525, 585
11, 10, 520, 582
I wish to add Tournament ranking as I have another table where the ranking
points are for each position, but I cannot update the Order of Merit, since
there is no linking fields between the order of the records at the moment.