Counting records

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 of that anomaly from the Events
table. The Events table will have any number of occurances of an anomaly
catagory.

My problem is I need a report from Anomaly Tracking that list 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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting records 1
Counting records in a report from multiple tables 0
Count in query 1
Conversion problem coming from Outlook 2003 to Outlook 2007 WinXPS 0
Help with Update Query 2
Difficult design query help needed!! 1
Convert Excel Table to Access Table 1
Finding total of one column while counting another 1

Top