Counting certain values in a field in Select Query

atiq

Registered User.
Local time
Today, 12:56
Joined
Apr 11, 2007
Messages
23
I am trying to count the total postive and negative behaviour incident. the name of the field is Category which is a combo box and has the values Minor, Major and Postive (these are the behaviour types. i want the query to count the total number of Postive and negative (this is Minor and Major) for the given results.

So, in simple words the actual select query finds the total incidents reported for a particular year group. from these resullt i want to be able to count how many positive and negative incidents will reported.

sorry am not very good with Access so could u give easy instructions. any help would be apprreciated.
 

Users who are viewing this thread

Back
Top Bottom