IIF name table (1 Viewer)

[melissafvoelker]

SELECT [asset class] , iif(ct2.[asset class]='3050', 'yes', 'Nope!') IIF_Example
FROM CONVERSION_TABLE_2 AS ct2;

The above isn't working because of my attempt to name the column.
I want to call the column "IIF_Example." Why doesn't it work?

Thanks

 

[FlyerMike]

SELECT [asset class] , iif(ct2.[asset class]='3050', 'yes', 'Nope!') as IIF_Example
FROM CONVERSION_TABLE_2;

I think the As was misplaced...

 

[melissafvoelker]

Access vs. SQL

yeah. i realized it, but i thought the as was optional.