I have two tables. The main table is escort_mileage and the details is extra_mileage. I have them set up good.
Under the extra_mileage table I have a record of miles. Then that gets totaled at the bottom of the page for total extra miles.
In the main table escort_mileage I have start_odometer and end_odometer records. With that I have a Query of: end_odometer - start_odometer as mileage. That Query gives me the miles ran.
What I would like to find out is can I have the total extra_mileage get listed on escort_mileage then add the two in a full total mileage?
So in extra_milage I would have miles ran, + extra miles, = total Miles
Hope I explained this right. Thank you for any help on this.
James Tandy