Every month reports

[Guest]

Hello,
I have a database that keeps track of all the equipments that are due for
maintenance. I run a report at the end of each month to be able to see what
is due for the next month, when the maintenance is completed, the operators
provide me the updated form and then I go to my form and update the
equipment for the next month.
There are some equipments that are due every month, Is there anyway I can do
a report that shows me all the ones that are due every month without going
and update the form every single month
I hope someone can help me
Thanks

 

[Guest]

How do you know what the maintenance interval for a piece of equipment is?
If you have that information in a table somewhere, you could use it to do the
update for you with a query.

 

[Guest]

Create a Periodic Maintenance (PM) table that list all the PM services you
will perform. In this table use the lowest common denominator of your
intervals. Most folks do not call a daily a PM but have weekly as the lowest
interval. If weekly is your lowest then compute all services in multiples of
weeks - a 2-month would be 9 weeks, 6 months would be 26 weeks.

Decide when the next PM will be scheduled based on last schedule or last
completed.

Build a junction table of all equipment, services (PMs), Last Schedule, Last
PM Complete, and flag for last schedule or last completed.

Run update query each time a PM work order is closed - flagged closed.

Create a Work Order table that has Equipment, PM, Schedule Date, Completed
Date, Maintainer, Comments (to be able to record exceptions and problems),
Closed, and other fields as needed.

Generate PM work orders each week for the next however many weeks you plan
in advance. Use an append query to generate the PM work orders.

 

[Guest]

Every time an equioment placed in service, there is a form that they complete
and it will ask the interval for that piece.
I have that info on my table, but I don't know how to use it and write a
code in query:-(
Thanks alot for your help

 

[Guest]

Thansk Karl,
I need to get all the equipments that are due every month on my report
regardless of updating them on a form or not.
Is there another way to be able to do that instead of creating PM.
I run a report for the equipments that are due next month and shows me the
one that are only due that month. This became a problem when we found out
beacuse one equipment needs maintenance every month, but they haven't been
doing it and the report didn't show that maintenance for not being updated.
I really appreciate your help
Thanks
Kamelia

 

[Guest]

You have to keep a record of when the maintenance was performed. The method
I laid out does that.

Use a query for the report that includes all open work orders, not just next
months work.