Просьба помощи по оптимизации запроса, долго обрабатыват зараза.

Пятница, 28 Февраля 2014 г. 02:54 + в цитатник

PARAMETERS [Forms]![frmDataSmeni]![dtpDataSmeni] DateTime;
SELECT tblObject.Object_Name, Avg(tblOpDataObject.Parametr) AS [Avg-Parametr]
FROM (tblObject INNER JOIN tblNitka ON tblObject.ID_Object = tblNitka.ID_Object) INNER JOIN tblOpDataObject ON tblNitka.ID_Nitka = tblOpDataObject.ID_Nitka
WHERE (((IIf(Nz(DateTimeFilter(Format([Forms]![frmDataSmeni]![dtpDataSmeni],"dd/mm/yyyy")))='',False,(Eval('''' & [DataSmeni]+[TimeSmeni] & ''' IN (' & DateTimeFilter(Format([Forms]![frmDataSmeni]![dtpDataSmeni],"dd/mm/yyyy")) & ')'))<>False))<>False))
GROUP BY tblObject.Object_Name, tblObject.Object_Number_Old
ORDER BY tblObject.Object_Number_Old;