主题：我的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 & "'

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