Se me ha ocurrido usar la función MAX para que almacene los registros más nuevos pero existe algún conflicto en la función.
Cita: mySQLac9== "SELECT AVG(DAY(DATE() - DAY(DATE_MESS))) FROM MESSAGES WHERE ID_REVERSE IN (SELECT ID_PART, Max(DATE_MESS), Max(TIME_MESS) FROM REVERSE where HOLD_STATUS='Ajustado')"
Cita: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.