gotcha wrote:The simplest (and most efficient) way to this is to use a group by query to> 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.
> 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]gilambry.com[/email]
retrieve the results into asp. Why can't you do this?
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.