Looks good, much easier than your original approach, SQL is great!
Bob
>thanks so much for the info, it worked.
>now there is one more thing that i need to do, i need to add up total minutes for each city as well and put it in a column.
>
>SELECT State, PADR(City,30), COUNT(*) AS Hits, sum(call_duration) as minutes ;
> FROM MyTable ;
> ORDER BY Hits DESC ;
> GROUP BY State, City
>
>would that work?
>Ryan
'If the people lead, the leaders will follow'
'War does not determine who is RIGHT, just who is LEFT'