ACC: "Circular Reference Caused by Alias" Error Message

Article translations Article translations
Article ID: 97526 - View products that this article applies to.
This article was previously published under Q97526
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

On This Page

SYMPTOMS

When you try to run a query, the query fails, and you receive the following error message:
Circular reference caused by alias '<field name>' in query definition's SELECT list.

CAUSE

The alias, or label, of a calculated field cannot be identical to any of the field names used to calculate the field.

RESOLUTION

Change the name of the alias or label used by the calculated expression or let Microsoft Access automatically assign an alias or label.

MORE INFORMATION

Steps to Reproduce Behavior


  1. Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).
  2. Create the following query based on the Products table:
          Query: Test Query
          -----------------------------------
          Type: Select Query
            Field: UnitPrice: [UnitPrice]/100
            Table: Products
    						

    NOTE: In versions 1.x and 2.0, there is a space in the Unit Price field name.
  3. On the Query menu, click Run. Note that you receive the following error message:
    Circular reference caused by alias 'UnitPrice' in query definition's SELECT list.
To resolve the error, replace the UnitPrice label with Price. For example:
Field: Price: [UnitPrice]/100
NOTE: In versions 1.x and 2.0, there is a space in Unit Price.

REFERENCES

For more information about renaming fields in queries, search the Help Index for "Renaming fields," or ask the Microsoft Access 97 Office Assistant.

Properties

Article ID: 97526 - Last Review: January 18, 2007 - Revision: 2.1
APPLIES TO
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Keywords: 
kberrmsg kbprb kbusage KB97526
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com