spider

Thanks efen. Your "start" is way beyond what I expected. I will look at it and see if I can figure out how it works. I dont know how to add traps so I will try to use what you've given me. Thanks again.

I'm sorry efen; I used your form incorrectly. It works perfectly. Thank you. I would not have ever figured that out on my own. I also need to sort on vehicle ID because I have more than one vehicle stored in the database, and then find the sum of the week ending milages for a quarter for each vehicle (Jan 1-Mar 31, Apr 1-Jun 30, Jul 1-Sep 30, Oct 1-Dec 31) and display them in a field for further use.

Thanks. 1. Why is weektotal "Unstored"? 2. Can the "endmiles" from a previous record be automatically entered into the "startmiles" of a new record?

I need to track mileage from one week to the next. * I need to initialize a record with the current milage (beginning odometer) reading. * One week later, enter milage for the week ending in a new record (ending odometer reading) and display the beginning odometer reading from the previous week (record). * Calculate the difference between the beginning odometer reading and the ending odometer reading. Make this value available for further calculations. * Repeat this process each week (a new record for each week ending) using the previous weeks ending odometer reading as the current weeks beginning odometer reading.