Adodc1.RecordSource = "select * from 单据 where [类别] LIKE (" + "'" + Trim(Combo1(1).Text) + "%'" + ") and [客户] LIKE (" + "'" + Trim(Combo1(0).Text) + "%'" + ") and [品名] LIKE (" + "'" + Trim(Combo1(2).Text) + "%'" + ") and [销售部门] LIKE (" + "'" + Trim(Combo1(3).Text) + "%'" + ") ORDER BY [单据号] ASC"我想加一个 日期的 要怎么加呢 比如 我还想查出 >=DTPicker1.Value adn <=DTPicker2.Value 又要怎么写啊 :) 谢谢!!!!!!!!!!!!!
解决方案 »
- 我用Setup Factory 打包软件,但是安装不覆盖老文件?
- 为什么点击鼠标并拖动选择范围的时候shape控件没有边框呢
- 急急
- frame内嵌窗体如何定位?
- 如何得到应用程序所在目录下一个文件夹里的所有的*.ini文件的名字并把它们全列举出来呀!!!!!
- 使用rar命令来压缩文件,文件大小有限制么?
- 大问题!!!!!!!来看看
- 用VBA调用EXE文件
- 谁有中文朗读的例子, 我有SPeech SdK 5.1,但我的例子只能朗读英文?
- 只让textbox输入数字,不让输入字符,要怎么做?
- 谁有“InstallShield6.31版东方语言包”的序列号,得到给分。
- 会用ActiveX的方法做多线程的,或能做稳定的多线程的老哥们请进! 我这里有的是分!!!
strsql=" select * from tablename where 日期字段=# " & dtpicker1.value & " # "
'数据库为SQL:
strsql=" select * from tablename where 日期字段='"& dtpicker1.value &"'"
strsql=" select * from tablename where 日期字段 between # " & dtpicker1.value & " # and # " & dtpicker2.value & " # "
'数据库为SQL:
strsql=" select * from tablename where 日期字段between '" & dtpicker1.value & " ' and '" & dtpicker2.value & " '"
Adodc1.RecordSource = "select * from 单据 where [类别] LIKE (" + "'" + Trim(Combo1(1).Text) + "%'" + ") and [客户] LIKE (" + "'" + Trim(Combo1(0).Text) + "%'" + ") and [品名] LIKE (" + "'" + Trim(Combo1(2).Text) + "%'" + ") and [销售部门] LIKE (" + "'" + Trim(Combo1(3).Text) + "%'" + ") and [单据号] LIKE (" + "'" + Trim(Text1(0).Text) + "%'" + ") and (日期 between # " & DTPicker1(2).Value & " # and # " & DTPicker1(0).Value & " # ) ORDER BY [单据号] ASC"谢谢你们