Re: Question about queries

[rob@xxxxxxxxx]

In the "Define result fields" I have:
DATEC       digits(ildate) 
YEARMONTH   substr(datec,1,6)
In the "Select sort fields" I used
Sort 
Prty A/D  Field 
  10  A   YEARMONTH
  20  A   ILSAL1 
In the "Select report summary functions" I used "1=Total" on ILQTY.
In "Define report breaks" I used
Break    Sort 
Level    Prty  Field 
  1        10  YEARMONTH
  2        20  ILSAL1 
In "Select output type and output form" I used "2=Summary only"

Results:
        YEARMONTH  Slsmn       MTD 
                   Number      Adjustments
 000001  200504         1 
 000002              TOTAL      948715.194
 000003 
 000004  200504         7 
 000005              TOTAL     1206903.000
 000006 
 000007  200504         8 
 000008              TOTAL       36649.000
...
000081 
000082  200504 
000083              TOTAL     8471378.233
...




Rob Berendt