Dim valg As String = "min(Tidspunkt), AVG(VannForing), AVG(Vannstand), AVG(Dosering), AVG(Hastighet), AVG(Silo), " & _

...

widh jus of group by Tidspunkt.. i dont get the AVG data, but all data,

when i try min(Tidspunkt), AVG(Vannforing),AVG.....

then i get the right data.

Thanks for the inputs:):)

some sample data from HistorTR table

48703 1 14/03/2008 21:27:57 45,72 228,6 11,43 0 -3276,8 -1329 -13,29 283,46 -13,29 2025,4 -107,1 -12605 -132,9 NULL NULL NULL

48704 1 14/03/2008 21:33:02 30,88 154,4 7,72 0 -3276,8 -1329 -13,29 283,46 -13,29 2025,4 -107,1 -12605 -132,9 NULL NULL NULL

48705 1 14/03/2008 23:38:05 17,88 89,4 4,47 0 -3276,8 99999 999,99 283,46 999,99 2025,4 -107,1 -12605 9999,9 NULL NULL NULL

48706 1 14/03/2008 23:43:09 4,96 24,8 1,24 0 -3276,8 99999 999,99 283,46 999,99 2025,4 -107,1 -12605 9999,9 NULL NULL NULL