ADO Help?

[javoine]

situation: I have a table that contains 3 fields: ID, NAME, DATE

The date field can contain 1 of 6 values (includes date/time). I want to be able to count the number of date/times that are the same.

In other words...if there are 3 entrys for 8/1/2003 2:00:00 AM and 5 for 8/1/2003 10:00:00 AM, I want to be able to count these seperatly...

I have my recordset on my ASP page, and can access my field, but how do I count the values seperatly?

Any help will be great.

Thanx

 

[cbokowski]

If you are running Sql Server this query should work.

select Count(Date), Date
from table
group by date
order by date