1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
| SELECT
Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],1,9) AS LOT,
Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,13) AS SERIE,
[UUT_RESULT].[START_DATE_TIME], [UUT_RESULT].[UUT_STATUS],
[STEP_RESULT].[STEP_NAME],
[STEP_RESULT].[STATUS],
[MEAS_NUMERICLIMIT].[DATA],
[MEAS_NUMERICLIMIT].[COMP_OPERATOR],
[MEAS_NUMERICLIMIT].[LOW_LIMIT],
[MEAS_NUMERICLIMIT].[HIGH_LIMIT],
[MEAS_NUMERICLIMIT].[UNITS]
FROM UUT_RESULT
INNER JOIN
(STEP_RESULT
INNER JOIN MEAS_NUMERICLIMIT
ON [STEP_RESULT].[ID]=[MEAS_NUMERICLIMIT].[STEP_RESULT]
)
ON [UUT_RESULT].[ID]=[STEP_RESULT].[UUT_RESULT]
WHERE
( ( Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],1,9)='" + Form5.Label3.Text + "')
AND ( Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,13)='" + Form5.TextBox2.Text + "')
AND ( Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,4)<>'" + Nothing + "')
AND (([UUT_RESULT].UUT_STATUS)='Passed')
AND ( UUT_RESULT.START_DATE_TIME IN
(SELECT Last(UUT_RESULT.START_DATE_TIME)
FROM UUT_RESULT
INNER JOIN STEP_RESULT
ON UUT_RESULT.ID = STEP_RESULT.UUT_RESULT
GROUP BY Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],1,9), Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,4), UUT_RESULT.UUT_STATUS)
)
AND ((STEP_RESULT.STEP_NAME)<>'MainSequence Callback')
AND ((STEP_RESULT.STATUS)<>'Skipped'))
GROUP BY Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],1,9), Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,13), [UUT_RESULT].[START_DATE_TIME], [UUT_RESULT].[UUT_STATUS], [STEP_RESULT].[STEP_NAME], [STEP_RESULT].[STATUS], [MEAS_NUMERICLIMIT].[DATA], [MEAS_NUMERICLIMIT].[COMP_OPERATOR], [MEAS_NUMERICLIMIT].[LOW_LIMIT], [MEAS_NUMERICLIMIT].[HIGH_LIMIT], [MEAS_NUMERICLIMIT].[UNITS]
ORDER BY Mid([UUT_RESULT]![UUT_SERIAL_NUMBER],10,13), [UUT_RESULT].[START_DATE_TIME] |
Partager