Vehicle maintenance database, n00b here. I have two tables. Table1 lists vehicles by field License (with other details). Table2 lists maintenance items, which includes the field License from the other table, as well as fields for Date and Odometer. I need to calculate the distance travelled by each vehicle in a quarter. So, I'm trying to figure out how to find the two records dated 12/31/2018 and 3/31/2019, subtract the Odometer values to determine the difference, and spit out a query/report with two fields: License and Miles Travelled. So, a list of all vehicles and how far they travelled in the designated time span. Help?
(Also, I updated my profile, but it doesn't seem to update this post. I'm using Windows 10, and Access 2007)