Hello,
I have an Access Query to pull work orders to identify projects that have existing work orders processed.
On one project, I may have multiple work orders. I would only like to pull the latest (last) work order processed. I have a WO_Processed_Date field that I would like to use to pull the latest date for the work order processed.
Example:
WO Num WO_Processed_Date
WO24444 3/1/2018
WO24444 3/5/2018
WO24444 4/6/2018
WO24444 5/20/2018
I have an Access Query to pull work orders to identify projects that have existing work orders processed.
On one project, I may have multiple work orders. I would only like to pull the latest (last) work order processed. I have a WO_Processed_Date field that I would like to use to pull the latest date for the work order processed.
Example:
WO Num WO_Processed_Date
WO24444 3/1/2018
WO24444 3/5/2018
WO24444 4/6/2018
WO24444 5/20/2018