>>Am I supposed to start the program with the first line, because I get an error when I do:
>>
>>;with counts as (select Id, count(Id) as frequency
>
>I posted you code to try in SQL Server Management Studio if you're using SQL Server.
>
>What is your back-end?

I do a lot of work in VFP. Can you suggest a statistics package that I can use within VFP? I've never used one. Thanks, Steve