Microsoft KB Archive/34120: Difference between revisions
m (Text replacement - ">" to ">") |
m (X010 moved page Microsoft KB Archive/Q34120 to Microsoft KB Archive/34120 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/") |
||
| (One intermediate revision by the same user not shown) | |||
| Line 25: | Line 25: | ||
Name Age | Name Age | ||
& | &s >40 | ||
The result would extract records containing Samson, Johnson and Smith. | The result would extract records containing Samson, Johnson and Smith. | ||
Copyright Microsoft Corporation 1989. | Copyright Microsoft Corporation 1989. | ||
Latest revision as of 19:21, 12 August 2020
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
<20 >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.
