Date Count

[brin]

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?

 

[simongallop]

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