SELECT UROKI.DAT, First(UR_TIME.TimeN) AS [First-TimeN], Last(UR_TIME.TimeK) AS [Last-TimeK], SPGRUP.NAIM, SPTEM.NAIM, SPKAUD.KAUDI, SPPREP.FAMIO, SPTIPZ.NAIM, Count(UROKI.DAT) AS [Count-DAT]
FROM ((((SPTEM INNER JOIN (UR_TIME INNER JOIN (UROKI INNER JOIN SPGRUP ON UROKI.IDG = SPGRUP.IDG) ON UR_TIME.IDUR = UROKI.UR) ON SPTEM.IDTU = UROKI.IDTU) LEFT JOIN SPKAUD ON UROKI.IDA = SPKAUD.IDA) INNER JOIN SPPREP ON UROKI.IDP = SPPREP.IDP) INNER JOIN SPNAGR ON UROKI.IDN = SPNAGR.IDN) INNER JOIN SPTIPZ ON SPNAGR.IDZ = SPTIPZ.IDZ
GROUP BY UROKI.DAT, SPGRUP.NAIM, SPTEM.NAIM, SPKAUD.KAUDI, SPPREP.FAMIO, SPTIPZ.NAIM
HAVING (((UROKI.DAT)=#10/5/2016#));

SELECT UROKI.DAT, FIRST(UR_TIME.TimeN) AS [First-TimeN],
 LAST(UR_TIME.TimeK) AS [Last-TimeK], SPGRUP.NAIM, SPTEM.NAIM, SPKAUD.KAUDI,
 SPPREP.FAMIO, SPTIPZ.NAIM, COUNT(UROKI.DAT) AS [Count-DAT]
 
FROM ((((SPTEM
 INNER JOIN (UR_TIME
 INNER JOIN (UROKI
 INNER JOIN SPGRUP ON UROKI.IDG = SPGRUP.IDG)
  ON UR_TIME.IDUR = UROKI.UR)
  ON SPTEM.IDTU = UROKI.IDTU)
 LEFT JOIN SPKAUD ON UROKI.IDA = SPKAUD.IDA)
 INNER JOIN SPPREP ON UROKI.IDP = SPPREP.IDP)
 INNER JOIN SPNAGR ON UROKI.IDN = SPNAGR.IDN)
 INNER JOIN SPTIPZ ON SPNAGR.IDZ = SPTIPZ.IDZ
 
GROUP BY UROKI.DAT, SPGRUP.NAIM, SPTEM.NAIM, SPKAUD.KAUDI,
 SPPREP.FAMIO, SPTIPZ.NAIM