PLEASE throw me a bone on this one...
I have a table of "TimeClock" punches for employees. They are listed in the normal, horizontal record fashion by punch time & date:
PUNCHINDEX, EMPID, TIMESTAMP, TIMEUSED (representing the time since the last punch)
I need to display this information vertically in a DBGrid of two weeks of possible days for a given employee. So it would look like this but for a two week period:
SATURDAY SUNDAY MONDAY TUESDAY
1/10/04 1/11/04 1/12/04 1/13/04
<blank> <blank> 09:00:00a 09:30:00a
<blank> <blank> 12:30:00p 01:30:00p
<blank> <blank> 01:30:00p etc...
<blank> <blank> 05:00:00p
I have tinkered with crosstab queries with little success because of the way they format the data but there is probably something I am missing.
Anything you can suggest would be appreciated.
I have a table of "TimeClock" punches for employees. They are listed in the normal, horizontal record fashion by punch time & date:
PUNCHINDEX, EMPID, TIMESTAMP, TIMEUSED (representing the time since the last punch)
I need to display this information vertically in a DBGrid of two weeks of possible days for a given employee. So it would look like this but for a two week period:
SATURDAY SUNDAY MONDAY TUESDAY
1/10/04 1/11/04 1/12/04 1/13/04
<blank> <blank> 09:00:00a 09:30:00a
<blank> <blank> 12:30:00p 01:30:00p
<blank> <blank> 01:30:00p etc...
<blank> <blank> 05:00:00p
I have tinkered with crosstab queries with little success because of the way they format the data but there is probably something I am missing.
Anything you can suggest would be appreciated.
