G
Guest
I am using Access 2003
I am developing a Preventative Mtce program for our plant. The db is built
on Machine # and Operation #. Ex:
Mach # Oper# Date Completed
150 150-A (Check Oil) 10/1/06
150 150-B (Check Belts) 5/1/06
150 150-C (Do something) 8/1/05
140 140-A (check oil) 9/1/06
Note: The operation # contains the machine # and a letter A, B, C etc. The
letter signifies different prev mtce (pm) items that need to be done on a
particular machine and usually at different intervals (30, 60, 90 days etc.
Some items are only done annually). A lot of the machine only have 1 or 2
items that are included in PM, other machines may have up to 6 items that
need to be completed. So as time goes by each machine history will show the
same item being completed several time over the year(s).
I am trying to develop a report that will tell the mechanic when the next PM
is due. I am looking at a calculated field that would take the "last date"
an operation was completed for each machine, and add the frequency (30, 60,
90 Days etc) to come up with a "Next PM Due Date". But I do not know how to
indicate only the "last date" of an operation. Can anyone out there please
help me or at least point me in the right direction. I have tried so many
different things - but nothing has worked.
ps - I do not know how to write code.
Thank you - Aurora
I am developing a Preventative Mtce program for our plant. The db is built
on Machine # and Operation #. Ex:
Mach # Oper# Date Completed
150 150-A (Check Oil) 10/1/06
150 150-B (Check Belts) 5/1/06
150 150-C (Do something) 8/1/05
140 140-A (check oil) 9/1/06
Note: The operation # contains the machine # and a letter A, B, C etc. The
letter signifies different prev mtce (pm) items that need to be done on a
particular machine and usually at different intervals (30, 60, 90 days etc.
Some items are only done annually). A lot of the machine only have 1 or 2
items that are included in PM, other machines may have up to 6 items that
need to be completed. So as time goes by each machine history will show the
same item being completed several time over the year(s).
I am trying to develop a report that will tell the mechanic when the next PM
is due. I am looking at a calculated field that would take the "last date"
an operation was completed for each machine, and add the frequency (30, 60,
90 Days etc) to come up with a "Next PM Due Date". But I do not know how to
indicate only the "last date" of an operation. Can anyone out there please
help me or at least point me in the right direction. I have tried so many
different things - but nothing has worked.
ps - I do not know how to write code.
Thank you - Aurora