Microsoft KB Archive/95911

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

Article ID: 95911

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 Q95911



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



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



MORE INFORMATION
The following example assumes that you do not have a table in the query that contains a field named Field1:

  Create the following query:

     Query: QueryTest ---     Field: Field1: (1+2) Show: False Field: Field2: (Field1 + 5) Show: True  Run the query. Note that you receive a parameter prompt for Field1. Field1 must be included in the query's recordset in order for the calculation in Field2 to be performed correctly.

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 will not be able to run the query with these calculations.

Additional query words: queries expression

Keywords: kbinfo kbusage KB95911

-

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

© Microsoft Corporation. All rights reserved.