代码如下:
strsql = "select sum(convert(int,precipitation)) as aaa from TabTimeData where ObservTimes >= '" & strd1 & "'" & " and ObservTimes <= '" & mydata & mytime & "'" & " and StationNum='" & mystation & "'"
db_num.OpenRecordset (strsql)
Debug.Print aaa
strsql = "select sum(convert(int,precipitation)) as aaa from TabTimeData where ObservTimes >= '" & strd1 & "'" & " and ObservTimes <= '" & mydata & mytime & "'" & " and StationNum='" & mystation & "'"
db_num.OpenRecordset (strsql)
Debug.Print aaa
你可以用val代替啊,如:
sum(val(precipitation))
其实是VBA的机制在起作用啊。
strsql = "select sum(val(precipitation)) as aaa from TabTimeData where 条件
db_num.OpenRecordset (strsql)
Debug.Print aaa
这样也不行呀!没有得到结果aaa啊!
debug.print db_num!aaa
而不是:
debug.print aaa
strsql = "select sum(val(precipitation)) as aaa from TabTimeData where 条件
db_num.OpenRecordset (strsql)
debug.print db_num!aaa
提示:“在此集合中找不到此项目”
另外问一句,你的db_num是个什么类型的对象??我的意思是:debug.print 记录集!aaa