Microsoft KB Archive/97526

= ACC: &quot;Circular Reference Caused by Alias&quot; Error Message =

Article ID: 97526

Article Last Modified on 1/18/2007

-

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

-



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 ' ' 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.



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.

