Microsoft KB Archive/118751

= Works 3.0: Functions with Range Reference Cause GPF in Query =

Article ID: 118751

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Works 3.0 Standard Edition
 * 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.

