All right so here is what is going on. I have a query to mysql that query the database then SUM the fields which is fine. My problem is the averages, when I sum the average lets say the record 1 is 4.63 and the other one is 5.44 it calculate everything and
does not leave the decimal.
I wonder if when I do my
dim AverageField as new boundfield
AverageField.Datafield = "Average" and so on if I could add the decimal or even in the mysql query.
here is my query:
Dim GetDataCMD As New MySqlCommand("SELECT PlayerID, PlayerName, Season, Position, SUM(GamePlayed) AS GamePlayed, SUM(Minutes) AS Minutes, SUM(Victories) AS Victories, SUM(Defeat) AS Defeat, SUM(DefeatExtension) AS DefeatExtension, SUM(GoalsAgaints) AS GoalsAgaints, SUM(fights) AS Fights, SUM(Average) AS Average FROM PlayerStats " & _
"WHERE (Season=@Season) ...
Go to the complete details ...