请高手帮忙看看这段程序
SourceStr = "select snj_date,hk_id,swj_id,snj_id,snj_dl as dl,snj_df as df from temp1 " + _
"where " + tmpselpart + " and (snj_date> = ' " + _
TxtDate(DTPicker1.Value) + " ' and snj_date <= ' " + TxtDate(DTPicker2.Value) + " ') " + _
"order by snj_date, hk_id,swj_id,snj_id "

提示说语法错误，操作符丢失，帮忙给看一下

[解决办法]
debug.print SourceStr

放到查询分析器中执行，很容易就可以找到问题了。
[解决办法]
tmpselpart 没有操作符!!
[解决办法]
做个断点，察看下提交到数据库前 SourceStr 的值
[解决办法]
“tmpselpart”应该是个字段名吧，后面怎么就没了！！