Counting events on a date in a report

[raymondp]

I am trying to create a report that will count the number of events within a
specific column for one day. Data is pulled from a single table called
"Significant Events Data Table 01".

For example:
8/1/2007 (Group Header, [Log Date])
[Station] [Sensor] [Mooring] [Metadata] (column
headings)
Restored
Failed
Other (events to be counted)
Failed Other
------------------------------------------------------------
Totals 2 1 1 1

The idea is to have the report look like this:
Station Sensor Mooring Metadata

8/1/2007
Totals 2 1 1 1

8/2/2007
Totals 4 2 3 1

and so on. I am able to get the total count of events over the entire
report that includes the entire month in the Report Footer section, but I
need to know how many events happened on a particular day.

Alternatively; if a table can be created that looks this:
Month day Station Sensor Mooring Metadata
1 1 2 1
2
2 1 5 2
1
3 3 1 4
2

That would also be great in addition to or instead of the report.

Any help on how to go about doing this would be greatly appreciated.

Cheers,
-Ray