>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?
censored.