Hello,
I created a database that keeps track of truck fuel logs and odometer readings. I am able to add the gallons of fuel used everyday in each truck, however I am having trouble subtracting the odometer readings to find the usage of each truck. I was able to create three queries, one that selects the first readings, one that selects the last reading, and one that combines the both and subtracts them. This works fine, but I would need to do it for every week and in order to do that I would have to create three queries every single week. I don't think that would be very efficient. Is there a better way I could subtract the readings every week and still keep a weekly log? Please let me know if I need to provide more information, and thank you in advance.
I created a database that keeps track of truck fuel logs and odometer readings. I am able to add the gallons of fuel used everyday in each truck, however I am having trouble subtracting the odometer readings to find the usage of each truck. I was able to create three queries, one that selects the first readings, one that selects the last reading, and one that combines the both and subtracts them. This works fine, but I would need to do it for every week and in order to do that I would have to create three queries every single week. I don't think that would be very efficient. Is there a better way I could subtract the readings every week and still keep a weekly log? Please let me know if I need to provide more information, and thank you in advance.
