Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 12th, 2015, 06:14 AM
Registered User
 
Join Date: May 2015
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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





Similar Threads
Thread Thread Starter Forum Replies Last Post
join table using ms access ct VB.NET 1 October 23rd, 2006 03:16 PM
Reading a MS-Access table: PYee Javascript How-To 9 February 7th, 2005 08:12 AM
How to create table in Ms Access (TSQL) abdusalam SQL Server 2000 4 July 31st, 2004 01:54 AM
How to clone MS Access table in C# cameleon69 C# 0 January 21st, 2004 10:16 AM
MS Access Table Help Imran82 BOOK: Beginning Access VBA 0 December 23rd, 2003 08:17 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.