Microsoft KB Archive/61396

Works 2.00: Query Examples Are Incorrect

PSS ID Number: Q61396 Article last modified on 06-12-1996

2.00

MS-DOS

= SUMMARY =

In the first paragraph of page 226 of the “Microsoft Works Reference” manual for Microsoft Works for MS-DOS version 2.0, the query example <1500&>2500 on line 2 is incorrect. The query designates an item less than 1500 and greater than 2500. To query on values greater than 1500 and less than 2500, correct the query as follows:

1500&<2500 This query returns all values from 1501 to 2499.

In the second paragraph of page 226 of the “Microsoft Works Reference” manual, the query example =Deposit>1500|Last Name=“smith” on line 2 is incorrect. The query designates records in which the Deposit field is greater than 1500 and all records in which the Last Name field is Smith. To query on records in which the Deposit field amount is less than 1500 OR all records in which the last name is Smith, correct the query as follows:

=Deposit<1500|Last Name=“smith”

= MORE INFORMATION =

Queries are dependent on the operator used. Using “&” as the operator produces values that depend on one another (this parameter AND that parameter = the query value). Using the “|” symbol produces OR values.

For example, to set up a query that returns all the Smiths that live in Seattle, enter the following in the “name” field in the query screen:

==“Smith”&city=“seattle”

This query returns all records for Smiths who live in Seattle. By replacing the “&” symbol with the “|” symbol, the query returns all records for Smith and all records for Seattle.

For more information about applying a query, see pages 222-226 of the “Microsoft Works Reference” manual.

KBCategory: kbother KBSubcategory: dworkskb

Additional reference words: 2.00

=
================================================================ Copyright Microsoft Corporation 1996.