Sql server Query, having count(*)>1 and order by count(*) desc

[fran7]

Hi, I have this query to get a drop down list and that works fine. The trouble is I need to select another field from the table to give it a where clause but if I try I get an error message.

SQLQuery = "select tbl.country from tbl group by country HAVING COUNT(country) > 1 order by count(country) desc"

Any pointers would be great
Thanks
Richard

[Rabbit]

I don't see a where clause or the error message.