Question regarding creating a log...

[scottay]

My question may be a little confusing, but I'll do my best to make it understandable. At work we have a press that presses ceramic powder and periodically it needs to be lubricated with grease. Right now we use a form that I created in excel that works ok, but I want to get it into access for ease of use and keeping entries consistant... There's the overview, now comes the confusing part...

There are 4 lubrication schedules - a daily (8hrs), weekly (40hrs), monthly (160hrs) and a yearly (1600 hrs). What I'm looking for is a way to compute how many hours until the next lubrication. I have True/False checkboxes that will be checked when a lubrication is performed, so there are 4 of them.

It sounded simple when I first decided to do it, but it has actually turned into being quite complicated... Maybe it's me, but hopfully someone can give me some insight.

Thanks for any help

Scott

 

[pbaldy]

I assume it has an hour meter, and that the 4 schedules represent different services (each more comprehensive)? I'd have a table with fields for the meter reading and which service was performed. From there, it's simple to find the most recent of each type and calculate when the next is due.

 

[scottay]

Yes, it is an hour meter. And thank you for your reply. It gave me something to go on and sparked a new idea. Thanks!

 

[Dreamweaver]

Would this need to be a 7 day calculation or just say 5 working days missing weekends or don't ya need that sort of complication LOL.

Mick

 

[scottay]

Actually, it doesn't need any work week calcs at all... It's just a number of hours taken off the meter on the press. So that part is simple.