Jason: I don't think you need a special tool. You can use an fairly straight forward
SQL query .
Open your file. Choose "SQL Select" from the Query drop down menu. The blinking
cursor defaults to the "from Tables:" box. Leave it there and use the drop down
"Tables" menu (on the right) to select the table you want to query for the frequency
count.
In the "Select Columns:" box replace the " * " (or whatever else may be there) with
"Count(*)" from the "Aggregates" drop down list, and add the column you want to query
from the "Columns" drop down list so that you have "Count(*), ColumnName" (no quotes)
in the box.
The "where Condition:" box should be blank.
In the "Group by Columns:" box enter the same column name you are querying, and the
same with the "Order by Columns:" box.
Leave "Selection" in the "into Table Named:" box.
Make sure the "Browse Results" box is checked.
You can use the "Verify" button to make sure everything was entered reasonably
correctly, then hit the "OK" button.
You should now have a query browser pop up containing 2 columns: "Count" and the "name
of the column queried". The "name of the column queried" will have an entry for each
unique item found in the column, sorted, and the count will have the number of times
each item was encountered.
Use "Save Copy As" to save the query browser as a TAB file, or it can be immediately
used to update another file, or ???
...good luck ...Bob
Robert Karr
[EMAIL PROTECTED]
517-373-3028
517-373-0171 FAX
Science Research Assistant
Science and Technology Division
Legislative Service Bureau
Michigan State Legislature
124 West Allegan, 4th Floor
pob 30036
Lansing, MI 48909-7536
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
