Access数据库select * from board where mid(sendtime,1,4) between '1997' and '2002'
用Rs1.open "Select sum(Tdgl) from Agreement Where Substring(Bcrq,1,4) between '1997' And '2002'" ,conn 试一下
sql="Select sum(Tdgl) from Agreement Where Substring(Bcrq,1,4) between 1997 And 2002" Data.recordsource=sql; Data.refreshto griefforyou: Vb里有Substring()?
Bcrq的类型对吗? 1997和2002用不用引起来?
你用一个简单的查询sql="Select sum(Tdgl) from Agreement" 看在VB 中是否能通过
检查CONNECTIONSTRING 是否正确
如果不加Substring()就好用,真的气死我了?我搞不懂了
谢谢你,henrryzhang,我通过了,但我还是不明白为什么Substring()就不行????一会给你加分。thank you very much!
但在VB中;
Data.Recordsource=sql;
Data.Refresh
出错;提示:Substring()未定义??如何解决??谢谢!!!
试一下
Data.recordsource=sql;
Data.refreshto griefforyou:
Vb里有Substring()?
1997和2002用不用引起来?
看在VB 中是否能通过