Query Last Two Entries for each Vehicle to Determine Difference in Mileage

[ChuckM]

Hello,

I have a vehicle database that I am suppose to receive daily inspections for every vehicle. The table for the daily inspections records "Entry Key" (primary key), "Asset Key", "Inspection Date", "Reported By", "Mileage", "Hrs Engine", "Hrs PTO", and "Hrs Battery" of each vehicle. What I have been asked to do is create a report that will show the difference in date, mileage and hours from the last two entries. I do not receive inspections every day like I am supposed to.

Does anyone know of a way to accomplish this?

Thanks,


Chuck Murphy

[pbaldy]

See if this helps:

http://allenbrowne.com/subquery-01.html#AnotherRecord

You might like the one underneath too.

[ChuckM]

Thank you very much pbaldy. The second example was just what I needed.

[pbaldy]

Happy to help, and welcome to the site by the way!

[ChuckM]

Well, take that back. I now have a query with data for the last two entries on each vehicle. But I do not know how to separate the data (so I can create a last query and a previous to last query)...or calculate the data from the same query.

Hope that makes sense.