Mileage Alerts

[Mcal6096]

Hello, I am very basic with Access. I currently have a fleet management database. Along with other aspects, I added a fuel log. I would like to use the mileages entered on the fuel log, for specific vehicles, to alert me when that bus has driven 5,000 miles. Is there any way to do this?

[Bulzie]

How do you want to be alerted, do you want that field to turn red when the miles goes over 5000? Do you want an email to you? You could trigger something off of a calculation like:

AlertMe = DSum("BusMiles", "tblFuelLog", "BusID = " & Me.BusID) > 5000

You would need to provide more details on your table and fields, maybe some sample data also for folks to give you a more specific answer.

[ranman256]

in the figure,
i used the tService table to get the most recent service date of the vehicle. ( qsMaxSvcDate )
NOTE: yours will be 5000.. mine shows 100.

then
join this query with the tMilage table to show if it needs service. (qsBusSvcMilage)