* [EMAIL PROTECTED] [...] > Aha, now I have SUM(ROUND(how_much,2)), this works so far.
You should swap these two function calls, the way you are doing it you are summing up the rounded values, instead you should round the sum of the values: ROUND(SUM(how_much),2) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]