str = "select sum (工作工时) from 运送员工工作 where运送日期>=cdate('" & CDate(DTPicker1.Value) & "') and 运送日期<=cdate('" & CDate(DTPicker2.Value) & "')"
'rs.Close
Adodc1.RecordSource = sql
Set DataGrid1.DataSource = Adodc1
'rs.Open str, conn, adOpenStatic
Label5.Caption = "统计结果:总工时" & ??????? & "小时"
我想返回"SUM"值,请问上面一句中label5.capion中的????怎么写
'rs.Close
Adodc1.RecordSource = sql
Set DataGrid1.DataSource = Adodc1
'rs.Open str, conn, adOpenStatic
Label5.Caption = "统计结果:总工时" & ??????? & "小时"
我想返回"SUM"值,请问上面一句中label5.capion中的????怎么写
str = "select sum (工作工时) as 总工时 from 运送员工工作 where运送日期>=cdate('" & CDate ……………………然后
Label5.Caption = "统计结果:总工时" & Adodc1.datafield("总工时") & "小时"试试!
'rs.Close
Adodc1.RecordSource = sql
Set DataGrid1.DataSource = Adodc1
'rs.Open str, conn, adOpenStatic
Label5.Caption = "统计结果:总工时" & Adodc1.Recordset.Fields(0) & "小时"
应该是:
……
Label5.Caption = "统计结果:总工时" & Adodc1.Recordset.Fields("总工时") & "小时"
……