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.