ms-access: missing operator in query expression
- by every_answer_gets_a_point
i have this sql statement in access:
SELECT *
FROM (SELECT [Occurrence Number], [1 0 Preanalytical (Before Testing)], NULL, NULL,NULL FROM [Lab Occurrence Form]
WHERE NOT ([1 0 Preanalytical (Before Testing)] IS NULL)
UNION
SELECT [Occurrence Number], NULL, [2 0 Analytical (Testing Phase)], NULL,NULL FROM [Lab Occurrence Form] WHERE NOT…