Query on the latest date

DO you want to continue to show each record, but all of them to show the latest date? or do you want to show just the latest record for each unique combination of all the fields you've listed?  (or something else?)

Unique record based in EPD _IDENTIFIER.

Sorry ...use this SQl statement instead.

SELECT BCDW_PROD_V_VL_CAPTURE_CONTROL_V.EPD_IDENTIFIER, BCDW_PROD_V_VL_CAPTURE_CONTROL_V.LINE_NUMBER, BCDW_PROD_V_VL_CAPTURE_CONTROL_V.EPD_STATUS, BCDW_PROD_V_VL_EPD_STAGE_ACTION_V.STAGE_NAME, BCDW_PROD_V_VL_EPD_STAGE_ACTION_V.STAGE_STATUS, BCDW_PROD_V_VL_EPD_STAGE_ACTION_V.STATUS_CHANGE_TS, BCDW_PROD_V_VL_EPD_STAGE_ACTION_V.CURRENT_WORK_CENTER
FROM BCDW_PROD_V_VL_CAPTURE_CONTROL_V LEFT JOIN BCDW_PROD_V_VL_EPD_STAGE_ACTION_V ON BCDW_PROD_V_VL_CAPTURE_CONTROL_V.EPD_IDENTIFIER = BCDW_PROD_V_VL_EPD_STAGE_ACTION_V.EPD_IDENTIFIER;

Create a saved query that gives you the record with the latest date and then use that saved query instead of BCDW_PROD_V_VL_CAPTURE_CONTROL_V in your main query.

One version of the  saved query would be..

Select T.* from BCDW_PROD_V_VL_CAPTURE_CONTROL_V as T
Inner join
(Select EPD _IDENTIFIER, Max(EPD_STATUS_CHANGE_TS) as mdate from BCDW_PROD_V_VL_CAPTURE_CONTROL_V
group by EPD _IDENTIFIER) as q1
on t.EPD _IDENTIFIER= qry1.EPD _IDENTIFIER and t.EPD_STATUS_CHANGE_TS    = qry1.mdate

Don't get it.....

Do you mean it doesn't work or do you mean you don't understand why you have to do this?

Do not understand what to do with this.....

You existing query looks like it is built in the query grid.

You say you want to see only one record for each unique value of EPD _IDENTIFIER and that record should be the record with the latest date in EPD_STATUS_CHANGE_TS.

The query I posted selects the record with the latest date.
Select T.* from BCDW_PROD_V_VL_CAPTURE_CONTROL_V as T
Inner join
(Select EPD _IDENTIFIER, Max(EPD_STATUS_CHANGE_TS) as mdate from BCDW_PROD_V_VL_CAPTURE_CONTROL_V
group by EPD _IDENTIFIER) as q1
on t.EPD _IDENTIFIER= qry1.EPD _IDENTIFIER and t.EPD_STATUS_CHANGE_TS    = qry1.mdate

You need to paste this into the sql view of a new query and save it.
When you run this query you should get one record for each value of EPD _IDENTIFIER .

You now need to use this saved query in your main query instead of using the table BCDW_PROD_V_VL_CAPTURE_CONTROL_V

(if you then get multiple records for each EPD _IDENTIFIER you have to look at the other tables you are using and the joins you are using in the complete query.).
EPD _IDENTIFIER

Thanks, glad to help.