1886 Lynwood Drive/Concord, CA 94519
Telephone: (415) 735-7504

---

 Creating Queries

Introduction (Creating Queries)

This chapter explains how to use Database => Query to select the composite
Records that will be included in a report.  With this command, you can define a
set of selection rules called a query.  The resulting report will only include those
records that meet the selection criteria.
       
The explanation of Database => Query is presented in the following sections:
     Query Structure
     Developing and Modifying a Query
     Query Techniques
       
      
      
Query Structure

 Each query consists of one or more selection rules that instruct the program to
 Retrieve data selectively based on criteria that you establish.  To build a rule, 
 you select or enter elements using the Selection Rule dialog box explained in
 the next section.  Each selection rule consists of three elements:

   A field from the composite record structure;
   A comparison operator such as “equal to” (see Figure 12.2);
   A comparison value, which can be a field, value, list of values, or range
   To which the value of the first field is compared.