Re: Breaks in QM/Query? -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.