Works 3.0: Functions with Range Reference Cause GPF in Query (118751)


The information in this article applies to:

  • Microsoft Works 3.0
  • Microsoft Works 3.0a
  • Microsoft Works 3.0b
This article was previously published under Q118751

SYMPTOMS

Attempting to use functions that require a range reference in a database query causes a general protection (GP) fault when the query is applied. Functions that require range references are not supported in the database query and should not be used.

RESOLUTION

Do not attempt to use a function that requires a range reference in any database query.

MORE INFORMATION

For more information about range references, please refer to the "References" section at the end of this article.

Steps to Reproduce Problem

  1. Open the WINGLIST.WDB sample file in Works.
  2. From the Tools menu, choose Create New Query. The New Query dialog box should appear.
  3. In the New Query dialog box, choose Query View.
  4. Delete the default value "=Date Entered=" from the Date Entered field.
  5. In the Credit Limit field, enter the formula =MIN(Credit Limit) and press ENTER.
  6. From the View menu, choose List.
A general protection (GP) fault occurs.

Microsoft has confirmed this to be a problem in Works for Windows versions 3.0, 3.0a, and 3.0b. This problem no longer occurs in Works 4.0 and later.

REFERENCES

For more information about how to perform this task in Works, see your Works printed documentation or online Help.

"Microsoft Works for Windows User's Guide," version 3.0, pages 198-203, "Using cell and range references in a formula"
Modification Type:MajorLast Reviewed:9/25/2003
Keywords:KB118751
©2003 Microsoft Corporation. All rights reserved.