-- 我的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 & "\'
这个条件怎么都查不到数据