I am trying to make an app that will track truck and generator maintenance, logging mileage so that I can have a central place to check to see if a vehicle needs an oil change.
I already collect the mileage in another app, so I will have that data available to me.
Now I have a maintenance app where you will be able to log oil changes and other repairs. For now I only have a section for generators. Each generator has a specific barcode ID which is listed in the title.
For the generators they need an oil change every 100 hours of use or every 6 months.
Right now, I’m trying to figure out how to get the max hour count from this maintenance table and have it filter results to only show a specific generator.
I can’t figure out how to get the maximum hour counter . Anyone have any insight?
I think I have it figured out now…you definitely put me on the right track with Query…I think my hang up was not putting this query on the main table with each generator. I was trying to do it in the table with all the maintenance before that had each individual hour count.
yep, that’s the key.
I was going to suggest order by Date limit one and then use a Single Value. But what you have looks fine.
You might want an extra filter in your Query (Service Done) if you will have other types of Service.