Help with totals query

[dcf1999]

So I have a table and I'm trying to get totals for different fields per year. So it's for a fire department program I'm creating. The user enters data for each call made. There is a lot of data to enter into the table but the main items I'm trying to total are calls that are accidents, how many patient refusals, how many patient transports, and the amount of calls to the local college. I want the query grouped by year, then calculate the amount of each field for that year. I cannot, for the life of me, get this to work. Obviously I'm doing something wrong. This seems like such a simple query. Maybe I'm using the wrong type of query? I attached pictures of what I'm trying to do. The fields [kish] and [mva] are yes/no fields. The other two are number fields.



I want this query to be able to make a graph. I figured making a query first is the easiest thing to do.

[dcf1999]

Ok so the sum works on the table, but it's not counting the amount of "checked boxes" for mva and kish

[Welshgasman]

Use an IIF() function to test if the field is True, and then set to 1 or 0 if True or False.
Then use SUM() on that expression NOT Count

[dcf1999]

So I did this to the query and it seems to pull the correct values... I have a feeling it's not the best way.. but it works... I just don't want it to pull corrupt data.

Basically I summed the yes/no fields and it gives me a negative number (since a true is -1) then use the abs function to turn that into a positive number.

[Welshgasman]

Just as good.

[ssanfu]

Be aware that "Type" is a reserved word in Access and shouldn't be used as an object name.
Shouldn't use spaces on object names. (objects include fields, tables, queries, forms, reports, modules)
Names should be only letters and numbers (exception is the underscore). Do not begin a name with a number.

Problem names and reserved words in Access