R
Richardson
I am looking for a solution to a database problem that I think can be solved
within a query, but I am open to other suggestions.
A registration table contains finish positions for 3 races. In a query that
combines that table with a points table, each finish position is assigned
points and then a calculated field totals the points for the 3 races. The
query then sorts the racers by the final point total in descending order.
Now I need it to assign a final finish position value in the Registration
table based on the final points.
My thought was to do another calculated field that is a running count
(autonumber essentially) from 1.... based on the final points and then make
that update the primary table through an update query.
Here is an example to further explain.
Racer Heat1 Heat2 Heat 3 Final Points Final
Position (This is the field I need to create)
Joe 1 1 2 978
1
Jane 2 1 2 968
2
This number has to be stored in the table because it then links to several
other areas.
Please let me know if you have any suggestions.
Thanks,
Lori
within a query, but I am open to other suggestions.
A registration table contains finish positions for 3 races. In a query that
combines that table with a points table, each finish position is assigned
points and then a calculated field totals the points for the 3 races. The
query then sorts the racers by the final point total in descending order.
Now I need it to assign a final finish position value in the Registration
table based on the final points.
My thought was to do another calculated field that is a running count
(autonumber essentially) from 1.... based on the final points and then make
that update the primary table through an update query.
Here is an example to further explain.
Racer Heat1 Heat2 Heat 3 Final Points Final
Position (This is the field I need to create)
Joe 1 1 2 978
1
Jane 2 1 2 968
2
This number has to be stored in the table because it then links to several
other areas.
Please let me know if you have any suggestions.
Thanks,
Lori