ACC: "Circular Reference Caused by Alias" Error Message (97526)

Microsoft Access 1.0

Microsoft Access 1.1

Microsoft Access 2.0

Microsoft Access for Windows 95 7.0

Microsoft Access 97

This article was previously published under Q97526

Novice: Requires knowledge of the user interface on single-user computers.

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

Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0).

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.

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.

Modification Type:

Major

Last Reviewed:

5/9/2003

Keywords:

kberrmsg kbprb kbusage KB97526