ms-access: missing operator in query expression

Question

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 ([2 0 Analytical (Testing Phase)] IS NULL)
  UNION
  SELECT  [Occurrence Number],  NULL, NULL, [3 0 Postanalytical ( After Testing)],NULL FROM  [Lab Occurrence Form]  WHERE NOT ([3 0 Postanalytical ( After Testing)] IS NULL)
 UNION
  SELECT  [Occurrence Number],  NULL, NULL,NULL  [4 0 Other] FROM  [Lab Occurrence Form]  WHERE NOT ([4 0 Other] IS NULL)
)  AS mySubQuery
ORDER BY mySubQuery.[Occurrence Number];

everything was fine until i added the last line:

SELECT  [Occurrence Number],  NULL, NULL,NULL  [4 0 Other] FROM  [Lab Occurrence Form]  WHERE NOT ([4 0 Other] IS NULL)

i get this error:

syntax error (missing operator) in query expression 'NULL [4 0 Other]'

anyone have any clues why i am getting this error?

You really ought to use more rational field names.

David-W-Fenton
– David-W-Fenton

2010-05-14 03:00:19 +00:00
Commented May 14, 2010 at 3:00 — David-W-Fenton
– David-W-Fenton, Commented May 14, 2010 at 3:00

SLaks · Accepted Answer · 2010-05-13 00:52:51Z

3

You missed a comma:

NULL,  [4 0 Other]

answered May 13, 2010 at 0:52

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mdma Over a year ago

Kudos to SO - the query is more readable here than it is in the Access SQL view.

Collectives™ on Stack Overflow

ms-access: missing operator in query expression

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related