Write textbox value from report to an related query field

[Guest]

How do you write the value of a textbox in a report which calculate the value
using different textboxes in the report [ex. a textbox are used to calculate
the total points a athlete aquire by using fastest time and first or second
place [using a running sum textbox] to write this value in an related query
with a field named "Total". I then want to use this query field to determine
the total pionts af the athletes and then determine a winner as per total
pionts.

Thanks a lot

 

[Arvin Meyer [MVP]]

Reports cannot actively write data back to a table. You can calculate the
data and determine the winner based upon the calculation, without storing
that anywhere. Typically, it is poor design to store the results of
calculations, since they can always be recalculated from the values that are
stored.