ms-access: displaying column as "something else"

Question

i have the following access sql statement:

SELECT *
FROM (SELECT [Occurrence Number], [Occurrence Date], [1 0 Preanalytical (Before Testing)], [Cup Type], NULL as '2 0 Analytical (Testing Phase)', [2 0 Area], NULL,NULL FROM [Lab Occurrence Form] 
WHERE NOT ([1 0 Preanalytical (Before Testing)] IS NULL)

in this: NULL as '2 0 Analytical (Testing Phase)' when it displays the column it shows the single quote. if i remove the quote completely it gives me an error, if i use double quotes it shows me the double quotes in the resulting table

is it possible to not have it show any quotes?

Answer 1

Use square brackets around column names and single quotes around strings. Try using square brackets instead:

NULL as [2 0 Analytical (Testing Phase)]

Answer 2

Use same syntax as you have

NULL as [2 0 Analytical (Testing Phase)]