Hello, I am trying to create a database to store information about calls for my local fire department.
My current task/issue is creating a a means of storing the names of firefighters who responded to various calls over the years. I have already created a table, that is filled from a form, in which you can select active members from a combo box. Each of the names will be stored in one of 15 fields, labeled Responder01-Responder15 (small department, few active members, no real need for more than that). That part is done…
My problem is, at the end of the year, I want to be able to tally up how many times each member responded to calls. I want to be able to create some statistics for the Chief. I have tried the whole “union” thing, and the “group by” with no luck. Is there something simple that I am missing?
So far, this is my first project with Access, and any wisdom would be appreciated. Thanks in advance!