Recalculating down a column
I have a tabular database in which a column, "InspectionHrs", is a sum based upon other column values as well as the inspectionHrs from the day before (i.e. the row above).
I've noted that if I change the value of a single record, it won't recalculate the fields of the records below it. Does anybody know how I can induce recalculating on other records?
Thanks for the help.