ник: snipe
SELECT t.№, t.Дата, t.Время, Format(IIf(nz(DMin("[№]","[t]","[t].[№]>" & [№]),0)=0,"",
DLookUp("[время]","[t]","t.№="
& DMin("[№]","[t]","[t].[№]>" & [№]))-[время]),"Short Time")
AS Мин, t.[Код Кнопки],
Nz(DLookUp("[название кнопки]","кнопки","[к кнопки]='" & [код кнопки] & "'"),"Кнопка не зарегестрирована")
AS название, IIf([Код Кнопки]="006BD590" And DLookUp("[Код Кнопки]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))="00E8D48E"
And (([время]-DLookUp("[время]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))>=#00:10#
And [время]-DLookUp("[время]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))<=#00:30#) And ([Время] Between #12/30/1899 7:0:0# And #12/30/1899 8:30:0#)),"Начало работы","")
AS Прочее
FROM t;