Re: Breaks in QM/Query?

Yes.
And this is the first qmqry I've messed with in over a decade.

Select And Sequence Fields
Seq Field
10 A.ICLAS
20 A.IPROD
30 A.IOPB

Specify report formatting
Edit column formatting

For Usage and Edit, press F4 for list.
Usage Description
Break1 Highest level break
Break2 Second level break
Break3 Third level break
Break4 Fourth level break
Break5 Fifth level break
Break6 Lowest level break
Omit Omit column from report
Average Average of the column values
Count Number of column values
First First value in column
Last Last value in column
Maximum Maximum value in column
Minimum Minimum value in column
Sum Sum of values in column

Column Heading Usage
1 Itm_Cls BREAK1
2 Item_Number
3 Opening_Balance SUM

Itm Item Opening
Cls Number Balance
--- ----------------------------------- -------------------
00 A0019909314 .000
A0019909414 .000
A011/B946/B947 .000
A016 .000
A02019-1 .000
A02019-4 .000
A02268 A (1) .000
A02268 A (2) .000
...
-------------------
* .000

20 A024.00A00 .000
A024.00A16 .000
A024.00A16C005 .000
A024.00A21 .000
...
-------------------
* 10.000

30 A022766 .000
A037545 02 .000
A037546 02 .000
A037548 02 5.000
A037548 05 15.000
-------------------
* 20.000

50 A042P245 .000
A043L072 .000
A047U855 300.000
A052F654 .000
-------------------
* 300.000

===================
330.000


Rob Berendt