Flagging up service intervals using hours recorded (1 Viewer)

[Sam Summers]

Hi Guys,

I am far too useless and stupid to solve this effectively!
Tried and tried but just cannot see it!

I have different components that have different service intervals based on hours entered by the user when the item is first entered.
I need to set a warning that flags up as in this example:

Main Engines - service at 250 hours, with a warning of the service approaching at 175 hours and then this of course continues at every 250 hour interval.

I have created a service history table which gathers the running hours logged by the user after every use.

My idea was to possibly use vba to add 250 to the warning total each time the next 250 is reached but these seems inefficient?

Many thanks for any help in advance

 

[theDBguy]

Can you show us your table structure?

 

[Sam Summers]

Can you show us your table structure?

You need to use the bypass key to open it.

So its from two forms - 'Maintenance' and 'Service' and the warnings will be at 75 hours prior to service interval of 250 and then warning when the 250 interval is reached.
Hours entered may be anything as small as 6 hours