Determine High Error Categories

[Guest]

I am creating a database to track the number of errors in each error category
to determine the need for training. For each entry, Error_Category and
Num_of_Errors are recorded. I want to return the high error categories like.

Error Category Total # Errors for January
Allowed/Denied Incorrectly 63
Scanning Errors 44
Quanity Billed 31

Thanks.

 

[Duane Hookom]

What have you tried? Did you attempt a totals query like:

SELECT Error_Category, Sum(Num_of_Errors ) as NumOf
FROM tblNoNameGiven
WHERE Error_Date Between #1/1/2006# AND #1/31/2006#;

 

[Marshall Barton]

What have you tried? Did you attempt a totals query like:

SELECT Error_Category, Sum(Num_of_Errors ) as NumOf
FROM tblNoNameGiven
WHERE Error_Date Between #1/1/2006# AND #1/31/2006#;

GROUP BY Error_Category

 

[Duane Hookom]

Ooops, thanks Marsh