counting records

[Guest]

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.

The Events table will have any number of occurances of an anomaly
catagory. The Anomaly Tracking table will have 1 to 3 reasons why something
qualified for the catagory without listing every occurance of that anomaly
from the Events table.

My problem is I need a report from Anomaly Tracking that lists just the
catagories with the 1 to 3 reasons for qualifying, along with the other
Anomaly tracking 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?

 

[Guest]

Hi DaveN,

Not quite sure what you are getting at for the first part, but the second
part is easy...

Simply create a query that has the Events Table, and do a count of the
EventID grouped by EventCategory.

For the first part - do you mean a count of the number of "1st" reasons, and
a count of the "2nd" and "3rd" reasons, or all together... If you want them
seperate, use a similar method to above - one query for each of the 3 reasons
counting the Anomaly Tracking ID grouped by Reason.

Hope that helps...

Damian.