I am building a Forms named VEHICLE. I have this "km reading previous" and "km reading Current"... to get the Actual Mileage I used the TEXT BOX in Controls:

In Property Sheet:

Control Source: =Sum(([km reading current]-[km reading previous]))

I got the result correctly, But only in the first record, the next record shows the same total of mileage. How that it happens? Please help me.

Thanks

See it this helps:

Referring to a Field in the Previous Record or Next Record

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015

Thanks... i go to the query then make a TOTAL LINE: (([km reading current]-[km reading previous]))

Then got the results...