[VB6] Valori min e max

[Massimo Moretti]

In effetti la Qry era abbastanza complessa, ho cercato di sintetizzare.
L'Istruzione SQL che si trova all'interno di un Data Environment è la seguente:

SELECT Tbl_Running.Runner, Tbl_Running.Scarpa, SUM(Tbl_Running.Km) AS Km, LEFT(AVG(Tbl_Running.Speed), 5) AS Speed, LEFT(`Ant_Time_Km`, 4) AS Time_Km, MIN(Tbl_Running.Speed) AS Min_Speed, MAX(Tbl_Running.Speed) AS Max_Speed, SUM(Fix(Tbl_Running.Peso * Tbl_Running.Km * 0.9)) AS KCAL, SUM(Fix(Tbl_Running.Peso * Tbl_Running.Km / 20)) AS Grammi_Grassi, 60 / AVG(Tbl_Running.Speed) AS T_Km, LEFT(`T_Km`, 4) AS Espr1, RIGHT(`Espr1`, 2) AS Espr2, IIf(`Espr2` = `Espr1`, 0, `Espr2` * 6) AS Espr3, IIf(Len(`Espr3`) = 2, 0 & `Espr3`, IIf(Len(`Espr3`) = 1, `Espr3` & 0, `Espr3`)) AS Espr4, LEFT(`Espr4`, 2) AS Espr5, `Espr2` * `Espr2` AS Espr6, IIf(`Espr2` = `Espr1`, LEFT(`Espr1`, 2) & ", " & `Espr5`, IIf(`Espr2` + `Espr3` + `Espr4` = 0, LEFT(`T_Km`, 2) & `Espr5`, IIf(`Espr6` < 1, LEFT(`Espr1`, 2) & ", " & `Espr5`, LEFT(`T_Km`, 2) & `Espr5`))) AS Ant_Time_Km, LEFT(AVG(Tbl_Running.FC_Arrivo), 6) AS FC_Arrivo, COUNT(Tbl_Running.ID) AS Conteggio

FROM Tbl_Running WHERE Tbl_Running.Scarpa <> "NULL" GROUP BY Tbl_Running.Runner, Tbl_Running.Scarpa;

Non lamento dei risultati perchè tutti i dati che voglio ottenere sono corretti, tranne i valori Min e Max che... alcune volte sono errati, vedi allegato, ciao.