Circular reference cause by alias ‘Dist-CC’ in query definition’s SELECT list.

Asked By thomasredmall 750 points N/A Posted on - 08/02/2011

Warm greetings to all,

I am posting here an issue regarding MS Access. I pasted below an error message that I encountered while I was trying to run a query. When the query failed, I received the error message below.

Microsoft Office Access

Circular reference cause by alias ‘Dist-CC’ in query definition’s SELECT list.

I tried to review all the procedures that I made before I encountered the said error message. I have no idea about what went wrong which caused the error. This was also my first time to encounter this error.

Please help me solve this issue.

All your comments will be of great help to me in solving this issue.

Thanks a lot in advance.

• Status: Open
• Question Views: 3880
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By chocomaltee 0 points N/A #122750

Circular reference cause by alias ‘Dist-CC’ in query definition’s SELECT list.

Hi Thomasredmall!

The error message "Circular reference caused by alias <field name> in query definition's SELECT list" occurs when a label name or alias of a calculated field (in your case, it's ‘Distcc’) that is used in the query has the same name as any other field that is used in the calculation.

Please take note that an alias should be unique. So what you can do is try to change the label name or alias that is being used in the calculated expression or you can also just let MS Access assign label name or alias automatically.

Hope the solution works for you.

About chocomaltee

Questions
0

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 08/04/2011
• Question Category: MS Access