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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.