Форумы HiProg.com - MS ACCESS, VBA, VB

ник: snipe
как-то так

SELECT t.№, t.Дата, t.Время, Format(IIf(nz(DMin("[№]","[t]","[t].[№]>" & [№]),0)=0,"",DLookUp("[время]","[t]","t.№=" & DMin("[№]","[t]","[t].[№]>" & [№]))-[время]),"Short Time") AS Мин, t.[Код Кнопки], t.Название, IIf([название]="начало" And DLookUp("[Название]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))="Кнопка№1" And ([время]-DLookUp("[время]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))>=#00:10# And [время]-DLookUp("[время]","[t]","t.№=" & DMax("[№]","[t]","[t].[№]<" & [№]))<=#00:30#),"Начало работы","") AS Прочее
FROM t;