Microsoft KB Archive/76174

= Works: How to Query on Blank or Nonblank Fields =

Article ID: 76174

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition

-



This article was previously published under Q76174





SUMMARY
This article discusses how to query a Works database for all entries that contain a blank or nonblank field.

Works 4.0, 4.5, and 4.5a
To find all entries that are blank or nonblank respectively, do the following:


 * 1) On the Tools menu, click Filters.
 * 2) Select the desired Field name.
 * 3) Under Comparison, click Is Blank or Is Not Blank, as appropriate. Note that the Is Blank operator will also find records that contain only spaces.

Works for Windows 3.0
To query a Works 3.0 for Windows database for all entries that contain a blank or nonblank field, place the desired formula from the list below into the appropriate field in the query screen.

Works for Windows 2.x
To query a Works 2.0 for Windows database for all entries that contain a blank or nonblank field, place the desired formula from the list below into the appropriate field in the query screen.

Additional query words: 2.00 3.00 4.00 4.50 4.50a w_works db

Keywords: kbfaq kbhowto KB76174

-

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

© Microsoft Corporation. All rights reserved.