主题：请教，如何把小数点后面零除去？

如何把小数点后面零除去了，含小数点排序，不是按数字大小排序。这个如何解决？

Dim ss As String = "select dbo.ClearZero(sum(总费用)) as 金额,sum(货物件数) as 件数,dbo.ClearZero(sum(计价重量)) as 重量,dbo.ClearZero(sum(计价体积)) as 体积 from {托运单据} where 开单日期 = '"& d1 &"' and 销单否 = '否' and 单据性质 = '正常单' GROUP BY 客户简称"
Tables("S费用统计_Table1").Fill(ss,"baox",True)
Tables("S费用统计_table1").sort = "金额 desc"