CODEWITHSUNDEEP
sqlms-accessaliascircular-reference
user228058
user228058

Reputation: 475

Access sql query Circular Reference error

I'm creating a sql select query for an access database, and receiving a circular reference error, because my alias name is the same as a column name in my expression. Here is the fragment of my query:

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

This specific alias name is part of the requirements for the output. Is there any way to get around this without changing the alias name?

TIA

Upvotes: 4

Views: 14342

Answers (2)

Matthew Slyman
Matthew Slyman

Reputation: 356

Sometimes, this error can occur when the circular reference is actually within one of the queries used as the basis of the query you are working on (even when the basis query actually doesn't raise any errors, itself!) In this case, you should follow the recommendations in Microsoft's KB (knowledge-base) article 97526, for the basis query.

Upvotes: 0

Adriaan Stander
Adriaan Stander

Reputation: 166416

Add the table name/alias to the field. Something like

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

Upvotes: 14

Related Questions