Find/calculate last date

[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

 

[kingston via AccessMonster.com]

Create a query with all three fields in the order you show below. Next,
click the Totals button (looks like a rotated M). Group by Mach # and Oper#.
For [Date Completed], select Max. This will get you the first part of your
answer. You need to provide more information on how the intervals are
determined in order to add the correct amounts of time to the different
activities.

 

[Guest]

Thank you Kingston for trying to help me. The "next pm due date" is a
calculation based on the Date Completed (last date pm was completed) plus the
"Frequency" required which is in days - 30 days, 60 days, 90 days, 180 etc.
I did as you said and created a query with - machine #, operation #, date
completed and frequency and added the "next pm due date" as a calculated
field.
What do I do next?

aurora - 10/28/06