Works: How to Query on Blank or Nonblank Fields (76174)
The information in this article applies to:
- Microsoft Works for Windows 95, version 4.0
- Microsoft Works for Windows 95, version 4.0 4.0a
- Microsoft Works for Windows 95, version 4.0 4.5
- Microsoft Works for Windows 95, version 4.0 4.5a
- Microsoft Works 2.0
- Microsoft Works 3.0
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:
- On the Tools menu, click Filters.
- Select the desired Field name.
- 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.
|
| Blank field | ="" | | Nonblank field | = <>"" | | One space | = " " |
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.
|
| Blank field | ==0 | | Nonblank field | <>==0 | | One space | =" " |
| Modification Type: | Major | Last Reviewed: | 11/15/2004 |
|---|
| Keywords: | kbhowto KB76174 |
|---|
|