ACC: Calculated Fields Must Be Shown to Perform Calculations (95911)


The information in this article applies to:

  • 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 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:
  1. Create the following query: 
          Query: QueryTest
      ---------------------------
      Field: Field1: (1+2)
         Show: False
      Field: Field2: (Field1 + 5)
         Show: True
  2. 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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbinfo kbusage KB95911
©2002 Microsoft Corporation. All rights reserved.