Microsoft KB Archive/209659

= ACC2000: Calculated Fields Must Be Shown to Perform Calculations =

Article ID: 209659

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q209659



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

This article applies only to a Microsoft Access database (.mdb).



SUMMARY
If you have a calculated field named Expr1 in a query, and you have another field that is performing a calculation based on Expr1, and then the Show property of Expr1 must be selected in the query grid.



Example
In the following example, Expr2 performs a calculation using Expr1, which is also a calculated field.

NOTE: Even though this example does not use any fields from a table, a table must be included in the query. If you do not include a table in the query, you are not able to run the query with these calculations.  Create the following query:

Field: Expr1: (1+2)

Show: False

Field: Expr2: (Expr1 + 5)

Show: True

 Run the query.

Note that you receive a parameter prompt for Expr1. Expr1 must be included in the query's recordset for the calculation in Expr2 to be performed correctly.

Additional query words: queries expression

Keywords: kbhowto kbinfo kbusage KB209659

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.