D
DaveN
My database contain tables: Events, Anomaly Catagories, and Anomaly Tracking.
Anomaly Catagories is a lookup table of anomalies
Events contains: Event, AnomalyCatagory (lookup), Date/Time.
Anomaly Tracking contains: AnomalyCatagory (lookup), Firstdateseen, Reason,
Resolution, and Status.
Anomaly Tracking table will have 1 to 3 reasons why something qualified for
the catagory without listing every occurance. The Events table will have any
number of occurances of a catagory.
My problem is I need a report from Anomaly Tracking that list just the
catagories with the 2 or 3 reason for qualifying and other fields. I also
need a count of total number of occurance of a catagory from the Events
table. Any ideas on how to do this.
Anomaly Catagories is a lookup table of anomalies
Events contains: Event, AnomalyCatagory (lookup), Date/Time.
Anomaly Tracking contains: AnomalyCatagory (lookup), Firstdateseen, Reason,
Resolution, and Status.
Anomaly Tracking table will have 1 to 3 reasons why something qualified for
the catagory without listing every occurance. The Events table will have any
number of occurances of a catagory.
My problem is I need a report from Anomaly Tracking that list just the
catagories with the 2 or 3 reason for qualifying and other fields. I also
need a count of total number of occurance of a catagory from the Events
table. Any ideas on how to do this.