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

48703114/03/2008 21:27:5745,72228,611,430-3276,8-1329-13,29283,46-13,292025,4-107,1-12605-132,9NULLNULLNULL

48704114/03/2008 21:33:0230,88154,47,720-3276,8-1329-13,29283,46-13,292025,4-107,1-12605-132,9NULLNULLNULL

48705114/03/2008 23:38:0517,8889,44,470-3276,899999999,99283,46999,992025,4-107,1-126059999,9NULLNULLNULL

48706114/03/2008 23:43:094,9624,81,240-3276,899999999,99283,46999,992025,4-107,1-126059999,9NULLNULLNULL