shelbsassy
03-13-2012, 05:13 AM
I have almost the same question as Aussiebeasr did on a previous thread but since it was so old I thought I would start a new one.
What I need is relatively simple, or so I thought. I have employee names in one column and across the top are the dates of the week and hours are put under each employee for each day. A calculation is at the end calculating the total hours and then the summary has their rate multiplied for the gross pay. The way it is now, it seems about impossible to try and create a pivot table from that, at least on an ongoing basis.
I was pondering whether this should be done in Access vs Excel. I have exhausted searches on the internet trying to help me with what I am trying to do.
I have attached a copy of the workbook we are currently using so you can get a better idea of what I am trying to do.
Any help would be greatly appreciated. Thank you.
What I need is relatively simple, or so I thought. I have employee names in one column and across the top are the dates of the week and hours are put under each employee for each day. A calculation is at the end calculating the total hours and then the summary has their rate multiplied for the gross pay. The way it is now, it seems about impossible to try and create a pivot table from that, at least on an ongoing basis.
I was pondering whether this should be done in Access vs Excel. I have exhausted searches on the internet trying to help me with what I am trying to do.
I have attached a copy of the workbook we are currently using so you can get a better idea of what I am trying to do.
Any help would be greatly appreciated. Thank you.