Mozda ovako:
Code:
SELECT [pregled].Ime, (Format([Datum],"Short Date")) AS Expr1, Avg([pregled].Vrijednost) AS AvgOfVrijednost, Avg([pregled].[Cijena]) AS [AvgOfCijena]
FROM [pregled]
GROUP BY ([pregled].Ime), (Format([Datum],"Short Date")), (Int([Datum]));