I have created a database to be used as a timeclock.
The table (TimeClockHisto ry) contains the following fields:
TimeEventID*
Employee
ClockInDate
ClockIn
ReasonClockIn
ClockOutDate
ClockOut
ReasonClockOut
What I would like to do is create a report to display the time in the
following fashion (Date-Column Heading, ClockIn, ClockOut):
Date1 Date2 Date3 Date4 Date5 Date6
1:00 2:51
2:20 3:00 and so on....
2:25 3:20
4:00 4:30
Is there anyway to have the information display horizontally instead of
vertically? Also, I need to have each column start with a new date.
It has been suggested I use a Cross-Tab Query. I tried to use the
query, but I could not get it to work properly. Even getting this to
export to excel would be fine...
Any suggestions would be very helpfull!
Thank you!
Brad
The table (TimeClockHisto ry) contains the following fields:
TimeEventID*
Employee
ClockInDate
ClockIn
ReasonClockIn
ClockOutDate
ClockOut
ReasonClockOut
What I would like to do is create a report to display the time in the
following fashion (Date-Column Heading, ClockIn, ClockOut):
Date1 Date2 Date3 Date4 Date5 Date6
1:00 2:51
2:20 3:00 and so on....
2:25 3:20
4:00 4:30
Is there anyway to have the information display horizontally instead of
vertically? Also, I need to have each column start with a new date.
It has been suggested I use a Cross-Tab Query. I tried to use the
query, but I could not get it to work properly. Even getting this to
export to excel would be fine...
Any suggestions would be very helpfull!
Thank you!
Brad