CODEWITHSUNDEEP
sqlms-accessvba
Alex Gordon
Alex Gordon

Reputation: 60691

ms-access: displaying column as "something else"

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?

Upvotes: 1

Views: 276

Answers (2)

volody
volody

Reputation: 7189

Use same syntax as you have

NULL as [2 0 Analytical (Testing Phase)]

Upvotes: 1

Mark Byers
Mark Byers

Reputation: 838086

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

NULL as [2 0 Analytical (Testing Phase)]

Upvotes: 3

Related Questions