SELECT 工时表.姓名, 工时表.工时
FROM 工时表
WHERE
(工时表.姓名=forms![form1]![Text0] AND 工时表.工时=forms![form1]![Text2])OR
(工时表.姓名=forms![form1]![Text0] AND 工时表.工时 Is Null)OR
(工时表.姓名 Is Null AND 工时表.工时=forms![form1]![Text2]);
...全文
2612打赏收藏
条件查询失败
各位大神,为啥我这样写代码查询不出来呢 SELECT 工时表.姓名, 工时表.工时 FROM 工时表 WHERE (工时表.姓名=forms![form1]![Text0] AND 工时表.工时=forms![form1]![Text2])OR (工时表.姓名=forms![form1]![Text0] AND 工时表.工时 Is Null)OR (工时表.姓名 Is Null AND 工时表.工时=forms![form1]![Text2]);