I'm not even sure how to begin going about doing this.
I have a database that tracks recurring events (i.e. rehearsal, performance, meeting, etc) and how long they took. My table has an entry for each event and how long it took. How do I generate a report that breaks the information down by type of event (i.e. only one post of rehearsal) then shows how many hours was spent on the even (i.e. total number of hours spent in rehearsal)?
My main goal is not to have twenty different entries for rehearsal each showing 1 hour. I want to group all entries marked "rehearsal" into one report entry with the total beside it. Is this possible?