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

I don't know of any. Someone else made that suggestion, hopefully he'll clarify.