* PROPERTY OF BRANT PUTTKAMMER, PLEASE CONTACT ME IF YOU HAVE QUESTIONS * PLEASE USE CAUTION WHEN RUNNING THIS PROGRAM ON YOUR SYSTEM :SELECT TE.STATS WITH DATE GE "01 OCT 15" **** GRAB SELECT LIST BASED ON WHATEVER DATE YOU WANT TO USE 397618 records selected to list 0. >SELECT TE.STATS WITH TRANS_CODE = "10500" AND WITH OPER = "997" **** ONLY USE 10500 OR WHATEVER TCODE YOU FIND USEFUL, I USE THIS AS THE INITIAL LOGIN OR BALANCE OVERVIEW **** I ALSO LIMIT TO OPERATOR 997 AS THAT IS WHAT WE HAVE DEFINED IN OUR CHANNEL SETTINGS 75366 records selected to list 0. SORT TE.STATS BY TIME.HOUR BREAK.ON TIME.HOUR TOTAL COUNT ID.SUPP DET.SUPP **** SORT BY TIME.HOUR, DICTIONARY BELOW, SO YOU CAN TOTAL THE COUNT FOR THE 24 HOUR SPAN SORT TE.STATS BY TIME.HOUR BREAK.ON TIME.HOUR TOTAL COUNT ID.SUPP DET.SUPP 10:14:19 NOV 19 2015 1 HOUR...... ......... 00 503 01 265 02 178 03 164 04 296 05 787 06 1993 07 4723 08 6600 09 6693 10 6037 11 5393 12 4845 13 4381 14 4471 15 4368 16 4458 17 3859 18 3331 19 3313 20 3176 21 2738 22 1824 23 970 ========== TOTAL 75366 75366 records listed :CT DICT TE.STATS **** CREATE A NEW DICTIONARY IN TE.STATS Enter item name: TIME.HOUR TIME.HOUR 0001: I 0002: OCONV(FIELD(@ID,"*",2),"MT") ; IF @1 # "" THEN @1[1,2] ELSE @1 0003: 0004: HOUR 0005: 10R 0006: S : :CT DICT TE.STATS **** CREATE A NEW DICTIONARY IN TE.STATS Enter item name: COUNT COUNT 0001: V 0002: "1" 0003: 0004: 0005: 10R 0006: M :