reset all calculations

[chriswrcg]

If i have query's and tables that are performing calculations based on the value of one set parameter, how can I recalculate all records that have been entered previously if I change the value of that set parameter?



for example I am calculating performance based on times it takes to perform a task one time. That time is 6 minutes.
The person performs the task 10 times so the result will be 60 when 10*6=60
I have 4 people that perform the task and I enter each of their records individually and get each of their result.

If i go in and change the time to 5 the end result should be 50 when 10*5=50 but when I run the report it is still showing 60 until i open that persons individual record again and reset them.
Now they are showing 50 but everyone else is still showing 60.
Is there a way to reset everyone at once without having to open each individual record one at a time?

[pbaldy]

This is among the reasons why we typically recommend not storing calculated values. You can run an update query to update all records in the table.