主题：我的SQL报错

 S  elect userNum As 员工编号,UserName As 姓名,CreateTime As 日期,实际天数_出勤,实际天数_休假,出差_东胜,出差_呼市,出差_大同,出差_集宁,缺勤工日_病假,缺勤工日_事假,缺勤工日_丧假,缺勤工日_婚假,缺勤工日_产假,缺勤工日_旷工,缺勤工日_探亲,缺勤工日_陪护,缺勤工日_公休,缺勤工日_工伤,Department As 部门 FROM {KQ_考勤表} Where Year(CreateTime)=Datepart(Year,Getdate()) And Department='" & _Department & "'

_Department是全局变量，但是平时我都是这么写，今天Department='" & _Department & "'

这个条件怎么都查不到数据

msgbox("Department='" & _Department & "'") ‘显示什么？把条件直接放到数据库里查询有没有数据？

DataTables("KQ_考勤表").LoadFilter = "Department='" & _Department & "'"

加载正常，_Department等于1202，

用S elect * from {KQ_考勤表} where Department='" & _Department & "' 查不到数据

用S elect * from {KQ_考勤表} where Department= '1202' 正常