datagrid显示求和结果,小数位数太多解决办法

datagrid显示求和结果,小数位数太多VB窗体中的datagrid显示记录的好多列,其中包括第1列集体编号和第二列的

datagrid显示求和结果,小数位数太多
VB窗体中的datagrid显示记录的好多列,其中包括第1列集体编号和第二列的grzh(个人账户),小数位数为2。我想按集体分组显示grzh的求和结果:
 Private Sub Command3_Click()
  Me.DataGrid1.Columns(1).NumberFormat = "0.00"

  Adodc1.RecordSource = "select bh, sum(grzh) as 发放总金额 from sdtx group by bh union select '总计',  
  sum(grzh)as 发放总金额 from sdtx"
  Adodc1.Refresh
End Sub

查询后的第一列为编号,第二列为分组的求和结果,但小数位数有十几位之多,怎么解决啊,谢谢

[解决办法]
format 函数
[解决办法]

VB code
Private Sub Command3_Click()  Adodc1.RecordSource = "select bh, sum(grzh) as 发放总金额 from sdtx group by bh union select '总计',    sum(grzh)as 发放总金额 from sdtx"  Adodc1.Refresh  Me.DataGrid1.Columns(1).NumberFormat = "0.00"End Sub