Microsoft KB Archive/34120

Entering Criteria in Database with “OR” PSS ID Number: Q34120 Article last modified on 01-09-1989 PSS database name: D_MPlan

4.00

MS-DOS

Summary: When using the database functions of Multiplan Version 4.00, the logical “OR” operation in the criteria can be achieved on operands of the same field by placing the members of the criteria in the same column. To do the same with operands of two different fields, place each member of the criteria in their corresponding columns, on two different rows.

More Information: For example, a database of names and ages would be created as follows:

Name Age

Samson 21 Jones 14 Johnson 54 Smith 34 Jackson 25

To extract records with ages less than 20 or greater than 40, enter the following criteria:

Age

40

The result would extract records containing Jones and Johnson.

To extract records with names starting with the letter S or with ages greater than 40, enter the following criteria:

Name Age

&s >40

The result would extract records containing Samson, Johnson and Smith.

Copyright Microsoft Corporation 1989.