Microsoft KB Archive/29308

Works: Querying on Blank, or Nonblank Fields in the Database

PSS ID Number: Q29308 Article last modified on 10-16-1998

1.00 1.05 2.00 3.00

MS-DOS

=
========================================================= 1.00 1.05 2.00 3.00 MS-DOS kbother null

= SUMMARY =

In the Works Database, insert the following in the appropriate field on the Define Query screen for the desired query:

Works versions 1.x and 2.0:

Query Insert —– ——

Blank field ==0 or =~ Space in a field =&quot; &quot; Nonblank field <>==0 or =

Works version 3.0:

Query Insert —– ——

Blank field or space in field ==&quot;&quot; Nonblank field <>&quot;&quot;

For more information on querying, see Page 351 or Page 405 in the “Works Reference” for version 1.05 manual, or Page 222 in the “Works Reference” for version 2.00 manual.

KBCategory: kbother KBSubcategory: dworkskb

= Additional reference words: 1.00 1.05 2.00 3.00 =

Version : 1.00 1.05 2.00 3.00 Platform : MS-DOS ============================================================================= Copyright Microsoft Corporation 1998.