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.
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.
The alias, or label, of a calculated field cannot be identical to any of the field names used to calculate the field.
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
Field: Price: [UnitPrice]/100
NOTE: In versions 1.x and 2.0, there is a space in Unit Price.
For more information about renaming fields in queries, search the Help Index for "Renaming fields," or ask the Microsoft Access 97 Office Assistant.
Article ID: 97526 - Last Review: January 18, 2007 - Revision: 2.1