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