SELECT timesheets. Name, ing table.
The FROM timesheets
WHERE
(timesheets. Name=forms! [form1]! [Text0] AND timesheets. Hours=forms! [form1]! [Text2]) OR
(timesheets. Name=forms! [form1]! [Text0] AND timesheets. Working hours Is Null) OR
(timesheets. Name Is Null AND timesheets. Hours=forms! [form1]! [Text2]);
CodePudding user response:
Have Spaces before and after the OR?Ever tried:
SELECT timesheets. Name, ing table.
The FROM timesheets
WHERE timesheets. Name=forms! [form1]! [Text0] or timesheets. Hours=forms! [form1]! [Text2];
CodePudding user response:
Is need a space before and after, the following ways if you need to meet will not be able to query the two conditions