Hello,
I have 2 tables: a Loss Run containing injury information at each store and a list of monthly store hours.
I need to merge both these tables into 1, so that I can export it into excel and create a dashboard (using excel 2010).
I'm having a hell of a time figuring out how to do this.
Store hours are sent accumulated on a monthly basis. For instance, for this last month, store 1 might say 5/1/2016 = 2777 hours. This is a sum of all of May's hours, not the specific date.
Secondly, each store may have more than 1 injury per day. For instance, store 1 may have 2 or more injuries on 5/1/16, and I need specific injury information for each injury, so each injury will need it's own row.
The problem I am running into is either hours or injuries are being duplicated as seen below:
<tbody>
</tbody>
I am not very good with Access or SQL and am not too sure on how to do a Union Query correctly.
Can someone please assist?
I am able to send you the excel workbook containing these tables. I'm not sure how to attach documents directly on this site...
I have 2 tables: a Loss Run containing injury information at each store and a list of monthly store hours.
I need to merge both these tables into 1, so that I can export it into excel and create a dashboard (using excel 2010).
I'm having a hell of a time figuring out how to do this.
Store hours are sent accumulated on a monthly basis. For instance, for this last month, store 1 might say 5/1/2016 = 2777 hours. This is a sum of all of May's hours, not the specific date.
Secondly, each store may have more than 1 injury per day. For instance, store 1 may have 2 or more injuries on 5/1/16, and I need specific injury information for each injury, so each injury will need it's own row.
The problem I am running into is either hours or injuries are being duplicated as seen below:
Store | Date | Hours | Injuries | Injury Type |
1 | 1/1/2012 | 2000 | 0 | |
1 | 2/1/2012 | 2500 | 1 | Strain |
1 | 2/1/2012 | 2500 | 1 | Laceration |
1 | 3/1/2012 | 2300 | 0 | |
1 | 4/1/2012 | 2500 | 1 | Contusion |
1 | 5/1/2012 | 2300 | 0 | |
1 | 6/1/2012 | 2600 | 1 | Sprain |
<tbody>
</tbody>
I am not very good with Access or SQL and am not too sure on how to do a Union Query correctly.
Can someone please assist?
I am able to send you the excel workbook containing these tables. I'm not sure how to attach documents directly on this site...