Performing Query Functions › Charge Query Panels › Charge Query Specifications Entry Field Options › Example 2: Entering Selection Criteria within the Period Number Field

Example 2: Entering Selection Criteria within the Period Number Field

To select the records that meet the criterion Period Number > = 001 and < 003 in a summary-with-breaks report:

• Set the Summarize and Break fields to Y (see A below)
• Enter 001 in the first field for Period Number and 003 in the second field (see B below)
• Set the Brk field next to Period Number to Y, so that results display by period number (see C below)

 +-----------------------------------------------------------------------------+
 | Type information for Query CPUCOST   Desc CPU COST FOR PER.1-3    Table TAB |
 |             A.                                                              |
 | Summarize Y  Break Y  Bud/DBCR N           Version : PROD PROD              |
 |                                   Brk Srt                            Op Sum |
 | ORD Type . . . .                   N      Rec Count                   > SUM |
 | Charge Element .                   N      Units  . .                  > SUM |
 | Qualifier  . . .        B.         N      Rate . . .                  > AVG |
 | Period Number  . 001   thru   003  Y   C. Charge . .                  > SUM |
 | DIVISION . . . .                   N                                        |
 | DEPARTMENT . . .                   N                                        |
 |                                                                             |
 |   F2=Exec   F5=Save   F6=Delete   F11=Refresh                               |
 +-----------------------------------------------------------------------------+

The next panel shows the results of entering a numeric value in the Period Number field.

• Three groups of records meet the criteria specified: Period Number > or = 001 and Period Number < or = 003 (see A below). Row 1 on the panel below shows the group of records that fall within period 1. Rows 2 and 3 (not shown) contain those records that fall within periods 2 and 3, respectively.
• The Record Count, Units, and Charge fields show the total amount of record count, units, and charges of those records that fall in period 1 (see B, C, and E below).
• The Rate field shows the average rate of the resulting records (see D below).

 +-- CBQQRYB ----------------- Charge Query Results ---------------------------+
 |       Panel   Exit   Help                                                   |
 | --------------------------------------------------------------------A.----- |
 |                                          More: + - 1     Row: 0001 of 0003  |
 |  Table  . . . . . : TAB                                                     |
 |  Version  . . . . : PROD PROD         Record Count :              2    B.   |
 |  ORD Type . . . . :                   Units  . . . :        2.00000      C. |
 |  Charge Element . :                   Rate . . . . :         .50000 AVG   D.|
 |  Qualifier  . . . :                   Charge . . . :        1.00000    E.   |
  > Period Number  . : 1                 Debit Amt  . :                        |
 |  DIVISION . . . . :                   Credit Amt . :                        |
 |  DEPARTMENT . . . :                   Adjust Charge:                        |
 |                                       Budget . . . :                        |
 |                                       % of Budget  :                        |
 |                                                                             |
 |   F7=Bkwd   F8=Fwd                                                          |
 +-----------------------------------------------------------------------------+