[Stackoverflow] [Progress OpenEdge ABL] How to only show results if count if more than 5

Status
Not open for further replies.
D

Duke578

Guest
Is it possible to only show results where by the same cust-num appears more than 3 times.

I have tried using a variable ( count = count + 1.). but its counting all the results .

icount = kcount + 1.
display
cust-name cust-num state count



Cust Num Name State Count
1001 Apple NH 1
1001 Apple NH 2
1001 Apple NH 3
1002 Orange BD 6
1002 Orange BD 7
1002 Orange BD 8
1002 Orange BD 9

Expected

Cust Num Name State Count
1001 Apple NH 1
1002 Orange BD 2

Continue reading...
 
Status
Not open for further replies.
Top