Timecard tracking and pivot tables

[shelbsassy]

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 a sample of the workbook we are using that I can email.

Any help would be greatly appreciated. Thank you.

 

[cyrilbrd]

Hi,
What do you want to see on your pivot?

 

[Smitty]

Welcome to the Board!

Why do you need a PT? It seems like your data is pretty well laid out now. Have you tried seeing if AutoFilter will do what you need?

If you'd like to post a shot of your sheet, just follow the HTML Maker link in my sig.