Access to SQL query Circular reference error

Question

I create a sql select query for an access database and get a circular link error because my alias name matches the column name in my expression. Here is a snippet of my request:

switch([CULET]='N','NONE', [CULET]='S', 'SMALL',[CULET]='VS','VERY SMALL', [CULET]='SL','  ',[CULET]='MD','  ') AS [Culet] 

This particular alias name is part of the release requirements. Is there any way around this without changing the alias?

TIA

Answer 1

Add the table name / alias to the field. Sort of

Switch([Table1.CULET]='N','NONE',[Table1.CULET]='S','SMALL',[Table1.CULET]='VS','VERY SMALL',[Table1.CULET]='SL','  ',[Table1.CULET]='MD','  ') AS Culet

Answer 2

, , , ( , !). case, Microsoft KB ( ) 97526 .