Count columns in Microsoft Access using Visual Basic 6.0

[sookfuny1984]

In mysql, there is a query like
select columnname, count(columnnam e) from tablename group by columnname

If I wan to use Microsoft Access in Visual Basic 6.0 to do the same thing, how am I going to do this? Because after I get the count number for the particular record in database, I need to do some calculation from it.
Anyone can help?
tq.