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
