machinetech
New member
- Local time
- Today, 03:45
- Joined
- Jun 10, 2019
- Messages
- 7
My company is keeping track of the maintenance on five of our machines.
I have a form to input the machine the maintenance was performed on, the date it was performed, and the severity of the maintenance, and job # as the primary id.
I then have a query that shows the maintenance record for just 1 of the five machines.
I would like to add a field in the query that calculates the number of days since the last maintenance was performed. To do this I need the value for the most recent maintenance date. I can not use the dlookup since the job # id is not in sequential order. Any help on this would be great.
Please let me know if I need to explain further.
JOB# Machine# MaintenanceDate Grade
1 1 3/1/18 A
2 3 3/1/18 B
3 1 4/20/18 A
4 2 5/1/18 C
What I want:
JOB# MACHINE# DATE GRADE PREVDATE #DAYS
1 1 3/1/18 A
3 1 4/20/18 A 3/1/18 50
I have a form to input the machine the maintenance was performed on, the date it was performed, and the severity of the maintenance, and job # as the primary id.
I then have a query that shows the maintenance record for just 1 of the five machines.
I would like to add a field in the query that calculates the number of days since the last maintenance was performed. To do this I need the value for the most recent maintenance date. I can not use the dlookup since the job # id is not in sequential order. Any help on this would be great.
Please let me know if I need to explain further.
JOB# Machine# MaintenanceDate Grade
1 1 3/1/18 A
2 3 3/1/18 B
3 1 4/20/18 A
4 2 5/1/18 C
What I want:
JOB# MACHINE# DATE GRADE PREVDATE #DAYS
1 1 3/1/18 A
3 1 4/20/18 A 3/1/18 50