Microsoft KB Archive/40461

Searching for Blank Entries in a Multiplan Database PSS ID Number: Q40461 Article last modified on 03-28-1990 PSS database name: D_MPlan

4.00 4.01 4.20

MS-DOS

Summary:

You can use the database features in Multiplan Versions 4.00, 4.01 or 4.20 to find blank entries by using a computed criterion to find any record with a length of zero (0). This method works for both text and number fields. To find blank entries, add a field in the database that calculates the length of a fieldname. Use the following formula:

LEN(fieldname)=0

Substitute for “fieldname” a reference to the appropriate column. Follow the instructions for using a computed criteria found in the “Microsoft Multiplan Addendum” on Pages A27-A28.

Copyright Microsoft Corporation 1990.