1 2 3 4
| SELECT DISTINCT [MASTER LIST].SIGNAL_NAME, [MASTER LIST].DESC, [MASTER LIST].CONTROLLER, [MASTER LIST].LOCATION, [MASTER LIST].HMI_SCREEN, [MASTER LIST].CABINET, [MASTER LIST].PWR_SRC, [MASTER LIST].TB_TYPE, [MASTER LIST].COL_ROW, [MASTER LIST].POINT, [MASTER LIST].[LOOP CHECK DATE], [MASTER LIST].[ICS ENGINEER]
FROM [MASTER LIST], [Loop Check Value]
WHERE (((IIf(Len([MASTER LIST]![LVL1])>4,(Left([MASTER LIST]![SIGNAL_NAME],2)),(Left([MASTER LIST]![SIGNAL_NAME],1))))=[FORMS]![KKS_PANEL]![LIST1]) AND ((IIf(Len([MASTER LIST]![lvl1])>4,(Mid([MASTER LIST]![signal_name],3,3)),(Mid([MASTER LIST]![signal_name],2,3))))=[FORMS]![KKS_PANEL]![LIST3])) AND (IIf(([LOOP CHECK VALUE].[LOOP CHECK VALUE]) = "Complete",([MASTER LIST].[LOOP CHECK DATE] IS NOT NULL),([MASTER LIST].[LOOP CHECK DATE] IS NULL))
ORDER BY [MASTER LIST].SIGNAL_NAME; |
Partager