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.

Welcome to the forums

Something like the attached?

miles.zip

Thanks.

1. Why is weektotal "Unstored"?

2. Can the "endmiles" from a previous record be automatically entered into the "startmiles" of a new record?

Can the "endmiles" from a previous record be automatically entered into the "startmiles" of a new record?

Yes. You can set the startmiles field to lookup or auto-enter the previous endmiles value. For this, you will need to define a relationship to the previous record first.

Can the "endmiles" from a previous record be automatically entered into the "startmiles" of a new record?

The sample file does enter the startmiles for a new record [?]

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.

Edited January 4, 201016 yr by Guest
Clarification

See attached for one way - this needs extra error traps and could probably be simplified, but it's a start

miles2.zip

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.