I have been asked to generate a report showing the costs for a piece of equipment based on the mileage range and I'm not sure where to start. One data file has the cost history by equipment # & date, and the meter reading & reading date are stored in another file. I'm looking to get the costs that occurred during the mileage ranges of 0-50,000, 50,001 - 100,000, 100,001 - 150,000, 150,001 - 200,000, and 200,000+.

Any suggestions on how to get the costs totaled based on the groupings by the dates of the various mileage ranges?

Thanks for any direction you can give me!