Hello,
I have an Access query that I use to pull work order data. When a WO is entered for a job (WO Create Date), there is a calculated date generated in a field called “Est Completion Date”. This date calculates from the date entered 60 days out. For example: Date Entered is 3/1/18. Est Completion Date will be 4/30/18.
Problem is, if there is another WO entered for the same site on 3/5/18, the Est Completion Date will be 5/4/18, etc.
How can I add another column in my query called “Proj Completion Date” to populate the last Est Competition Date entered?
I have uploaded a small sample table.
I appreciate your time and support. Thank you.
I have an Access query that I use to pull work order data. When a WO is entered for a job (WO Create Date), there is a calculated date generated in a field called “Est Completion Date”. This date calculates from the date entered 60 days out. For example: Date Entered is 3/1/18. Est Completion Date will be 4/30/18.
Problem is, if there is another WO entered for the same site on 3/5/18, the Est Completion Date will be 5/4/18, etc.
How can I add another column in my query called “Proj Completion Date” to populate the last Est Competition Date entered?
I have uploaded a small sample table.
I appreciate your time and support. Thank you.