Microsoft KB Archive/107849

From BetaArchive Wiki

FastTips: Database Questions and Answers (2.0/3.0)

PSS ID Number: Q107849 Article last modified on 06-26-1998

2.00 3.00

WINDOWS

==========================================================
The information in this article applies to:
- Microsoft Works for Windows, versions 2.0 and 3.0

SUMMARY

This article contains the Microsoft Works for Windows versions 2.0 and 3.0 Database Questions and Answers.

MORE INFORMATION

  1. Q. How many fonts can I use in my database?

    A. If you are using Works 3.0, you can use up to 510 fonts in the Database if your computer memory will allow it. If you are using Works 2.0, you can only use one font per area (that is in form view, list view, and the report).

  2. Q. In Works 2.0, how do I query on a blank field or on a field with a space in it?

    A. You can use formulas to query the Works 2.0 Database for all entries that contain a blank or non-blank field. In the query screen, insert the formula in the field on which you want to query.

    To query on entries in which the selected field is blank, use the following formula:

      ==0

    (That is, equal equal zero.)

    To query on entries in which the selected field is non-blank, use the following formula:

      =()

    (That is, equal left parenthesis right parenthesis.)

    To query on entries in which the selected field contains one
    space, use the following formula:
    
      =" "

    (That is, equal quotation marks space quotation marks.)

  3. Q. In Works 3.0, how do I query on a blank field or a field with a space in it?

    A. You can use formulas to query the Works 3.0 Database for all entries that contain a blank or non-blank field. In the query screen, put the formula into the field on which you want to query.

    To query on entries in which the selected field is blank, use the following formula:

      =""

    (That is equal, quotation marks quotation marks.)

    To query on entries in which the selected field is non-blank, use the following formula:

      = <>""

    (That is, equal space less than greater than quotation marks quotation marks.)

    To query on entries in which the selected field contains one space, use the following formula:

      = " "

    (That is, equal space quotation marks quotation marks.)

  4. Q. How do I create a multiple-line field?

    A. To create a multiple-line field in the Works Database form view, use the following two-step procedure:

    1. From the Format menu, choose Field Size.

    2. In the Height box, type the number of lines you want.

    NOTE: Works has a 256-character limit for each field.

    As you type in the multiple-line field, text will automatically wrap to the next line. To manually jump to the next line, press SHIFT+ENTER.

    NOTE: In Works 2.0, the multiple-line entries in the list view and reports appear on a single line. In Works 3.0, the row height in the list view and reports can be increased and the text wrapped by selecting Alignment from the Format menu.

  5. Q. How do I create a query in Works 2.0?

    A. Before you print a report or view a database in Works 2.0, you can use a query to define exactly which records you want to see or print. You can look for only those records that contain fields that match the definitions you specify.

    For example, to search for records in which a field contains a date of October 30, 1960 or later, enter the following query in the appropriate field in the query screen:

      >='10/30/60'

    (That is, greater-than equals single-quotation-mark ten forward- slash thirty forward-slash sixty single-quotation mark.)

    This searches for records that contain a date that is later than or equal to the specified date.

    For more information on creating queries, see pages 274 to 284 in the “Microsoft Works for Windows User s Guide.”

  6. Q. How do I perform text queries in Works 3.0?

    A. To perform text queries in the Works 3.0 Database, use the Query generator dialog box.

    To use the Query generator, use the following six-step procedure:

    1. If the file you want to do queries on is not already open, choose Open from the File menu. Select the file you want to open, and choose OK.

    2. From the Tools menu, choose Create New Query.

    3. In the Choose A Field To Compare box, select the field on which you want to query.

    4. In the How To Compare The Field box, select the operator you want to use in the query (for example, “is equal to”).

    5. In the Value To Compare The Field To box, type the text you want to find.

    6. Choose Apply Now to apply the query.

    NOTE: Do not include quotation marks in your query. Works will automatically insert them if necessary.

    To view the finished query formula, choose the Query View button.

  7. Q. Where can I go to find more information about querying on text in the Works Database?

    A. For more information about text queries in Works 3.0, refer to pages 357-360 in the “Microsoft Works for Windows User’s Guide.”

    For more information about text queries in Works 2.0, refer to pages 247-282 in the “Microsoft Works for Windows User’s Guide.”

    NOTE: There is a documentation error on page 282 of the “Microsoft Works for Windows User’s Guide” for Works 2.0. The examples on page 282 for querying on text in the Database are incorrect.

    If you are using equals signs, there should be quotation marks around the text and wildcard you are using for your query. For example, the first example reads as follows:

      =Test ?

    (That is, equals test space question mark)

    Instead, this should read as follows:

      ="Test ?"

    (That is, equals quotation marks test space question mark quotation marks.)

    If you are searching only for the text, you should omit the equals sign and the quotation marks. In other words, the query should read as follows:

      Test ?

    (That is, test space question mark.)

Additional reference words: kbhowto 2.00 3.00 q&a fast tips fastips

w_works

Keywords : wworkskb Version : 2.00 3.00 Platform : WINDOWS ============================================================================= Copyright Microsoft Corporation 1998.