Un bel casino
Prova con questa:
PARAMETERS DalGiorno DateTime, AlGiorno DateTime;
SELECT
Z01.UTENTE,
Max(Z01.MaPo) AS Maaa,
Min(Z01.MaPo) AS Miii,
StDev(Z01.MaPo) AS Dvvv
FROM
(
SELECT
NomeQuery.UTENTE,
NomeQuery.MATTINA AS MaPo
FROM
NomeQuery
WHERE
(((NomeQuery.DATA)>[DalGiorno] And (NomeQuery.DATA)<[AlGiorno]))
UNION ALL
SELECT
NomeQuery.UTENTE,
NomeQuery.POMERIGGIO AS MaPo
FROM
NomeQuery
WHERE
(((NomeQuery.DATA)>[DalGiorno] And (NomeQuery.DATA)<[AlGiorno]))
) AS Z01
GROUP BY
Z01.UTENTE
;
Facci sapere