|
Lim, You could use Query to create the summary. Order by Area Code, Prefix, Suffix, Terminal. Break level 1 on Area Code, Prefix, Terminal. Min & Max on Suffix. Output to a summary file. It won't let you output to your own file format. It will create a break level indicator field in the output file which you won't want. You also get a summary record with min and max on the Suffix over the entire file. But it does give you the detail you want. Paul
This mailing list archive is Copyright 1997-2026 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.