ACCESS: Calculation
I am making this Vehicle FORMs in database ACCESS. I have total previous and current reading of Mileage then i used the "text box" control for computing the Actual Mileage... i sum up with this calculation in text box.
Control Source: =Sum(([km reading current]-[km reading previous]))
I get the total mileage but in the next record it appears the same total mileage...
How that it happens? Please help me how to calculate?
Thanks
|