In mysql, there is a query like
select columnname, count(columnname) 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.