If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Counting events on a date in a report
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 |
Thread Tools | |
Display Modes | |
|
|