I have MS Access table
Hi
I have MS Access table
ID: Category City
01 Gemstones Peshawar
02 Gemstones Peshawar
03 Jewelry Peshawar
04 Gemstones Peshawar
05 Jewelry Peshawar
I want it search by City & Group by Category like this
Gemstones 03
Jewelry 02
I Use this step please help me in this regard
sql="SELECT Category, count(*) from MemberTable GROUP BY Category"
rs.Open sql, conn
do until rs.EOF
=rs.fields.item("T5").value
rs.MoveNext
loop
rs.close
|