I have a DICT item CNT setup as an I desc as (1=1) We use it like: SELECT FILENAME BY FIELD BREAK.ON FIELD TOTAL CNT DET.SUP
Which works great for giving counts of FIELD - but you can't sort by it, or select off it. I tried: SELECT FIELD,COUNT(CNT) FROM FILENAME GROUP BY FIELD; Which also does the same, hoping, I could add a WHERE COUNT(CNT) > 1 but it won't allow you to add that clause on with out an error: What I want to know is which FIELD's in FILENAME have a TOTALCNT > 1 Any ideas? (Either using TCL or SQL) UV 10 Thanks George George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator [email protected] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
