I have several cases which have started on different dates, some have started on the same date how can i get a count of cases on each dates. for e.g 01/01/2002=10 cases?? I keep getting a list o f the same date with a count of one?

Create a query with the case date field and any other field from the table. Goto Edit and the click on Totals. You want to group by date and then count for the second field. This will give you the number of records per date.

HTH

Count(*) is faster than Count(fieldname). You should be aware that the Count(fieldname) will not count any rows where fieldname is null so be careful how you use it.

Select YourDate, Count(*) As CountForDate
From YourTable
Group By YourDate;