Tables("CC收费系统_query").Fill("select sch as 校区, clas as 班级, freq as 每周课次, numWkOff as 请假周数, balance as 对应金额, dateLeave as 请假日期, refGen as 登记单号 from {wAb} where id = '" & x & "' and sch = '" & y & "' and clas = '" & z & "'", "test", True)
还有没有别的错,不敢说,前后缺少空格是肯定的。