>>Handy piece of code - you'll probably want to update it so it handles the newer data types (it hung up on a DateTime data type when I ran it on one of my tables, but I think it'll handle my client's data file fine).
>>
>>Thanks very much for sharing it!
>
>Change:
> If Type( "aStatistics[ 1 ]" ) == "D" Then
>into:
> If Type( "aStatistics[ 1 ]" ) $ "DT" Then
>
>In the mean time I am going to rewrite it so that it does the analysis in a single pass, with the option to add details (on a per field basis, or all fields) of a SELECT Distinct - which answers the question: for a particular column, how many different values are there?
>
>Any chance you can share your results?

Sure - as soon as the client gets the table to me I'll pass on the results. My peek at the table structure revealed pretty realistic field widths, but this analysis might buy us a few more months.