Need Asp recordset Group / Count like values

[gotcha]

Is there any way to group like objects, then count them in asp. I
have a table with 60,000 + part numbers that I need a total of each
one that is the same. For example.

Table:
000000-cpq
000000-cpq
000000-cpq
000000-cpq
199888-001
199888-001
199888-001
244166-001

Results:
000000-cpq = 4
199888-001 = 3
244166-001 = 1

I can do this in access with a simple group and count, but I need to
do it in asp. Thanks for any help in advance. [email]gil@ambry.com[/email]

[Bob Barrows [MVP]]

gotcha wrote:

> Is there any way to group like objects, then count them in asp. I
> have a table with 60,000 + part numbers that I need a total of each
> one that is the same. For example.
>
> Table:
> 000000-cpq
> 000000-cpq
> 000000-cpq
> 000000-cpq
> 199888-001
> 199888-001
> 199888-001
> 244166-001
>
> Results:
> 000000-cpq = 4
> 199888-001 = 3
> 244166-001 = 1
>
> I can do this in access with a simple group and count, but I need to
> do it in asp. Thanks for any help in advance. [email]gil@ambry.com[/email]

The simplest (and most efficient) way to this is to use a group by query to
retrieve the results into asp. Why can't you do this?

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Aaron [SQL Server MVP]]

> I can do this in access with a simple group and count, but I need to

> do it in asp.

This doesn't make any sense. Can you elaborate?

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)