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.