I set up a program that tracks the events in a hockey game by pressing a button for each event and puts it into a portal which also shows the time of the event.
My Tables: Hockey_Game::__pk_HID->Hockey_Action::_fk_HID
An example would be in the Hockey_Action Table:
Period Team Event Time
Period 1 Team 1 Shot 01:54
Period 1 Team 2 Goal 17:14
Period 2 Team 1 Offside 03:01
Because I separated the events Shot and Goal when it comes time to summarize the events by period it separates Goals from Shots.
So my question is when creating a report is there a way to combine or add two events and show them as one?
In other words, if I have 5 shots and 1 Goal in Period 1, how would I show Shots + Goals for a particular Period, and then at the end of the report also have a combined Shots + Goals? Or is there a better way to do this?
I'm sure this is easy, but for a newbie like myself I can't seem to wrap my head around on how to do it.