David B
Board Regular
- Joined
- Jun 3, 2006
- Messages
- 75
Hi Folks.
I have inherited a DB for staff clock in/outs. The staff use a barcode-card swipe the card as they start work etc:
Table looks like:'
ID, Emp_ID, Clock,
267, 10389 , 29/06/2011 07:44 AM
268 , 11987, 29/06/2011 08:14 AM
269, 11003, 29/06/2011 08:09 AM
270, 11678, 29/06/2011 07:59 AM
271, 11987, 29/06/2011 07:00 PM
272, 11003, 29/06/2011 05:04 PM
273, 11678 , 29/06/2011 03:17 PM
274, 10389, 29/06/2011 05:25 PM
How can I run a qry or a report that shows me the following the next day
ID, Emp_ID, Clock in, Clock out
267, 10389 , 29/06/2011 07:44 AM , 29/06/2011 05:25 PM
268, 11987, 29/06/2011 08:14 AM , 29/06/2011 07:00 PM
269 , 11003, 29/06/2011 08:09 AM , 29/06/2011 05:04 PM
270, 11678 , 29/06/2011 07:59 AM , 29/06/2011 03:17 PM
I cant work out how to have the out time show beside he in-time
Appreciate any suggestions
thanks db
I have inherited a DB for staff clock in/outs. The staff use a barcode-card swipe the card as they start work etc:
Table looks like:'
ID, Emp_ID, Clock,
267, 10389 , 29/06/2011 07:44 AM
268 , 11987, 29/06/2011 08:14 AM
269, 11003, 29/06/2011 08:09 AM
270, 11678, 29/06/2011 07:59 AM
271, 11987, 29/06/2011 07:00 PM
272, 11003, 29/06/2011 05:04 PM
273, 11678 , 29/06/2011 03:17 PM
274, 10389, 29/06/2011 05:25 PM
How can I run a qry or a report that shows me the following the next day
ID, Emp_ID, Clock in, Clock out
267, 10389 , 29/06/2011 07:44 AM , 29/06/2011 05:25 PM
268, 11987, 29/06/2011 08:14 AM , 29/06/2011 07:00 PM
269 , 11003, 29/06/2011 08:09 AM , 29/06/2011 05:04 PM
270, 11678 , 29/06/2011 07:59 AM , 29/06/2011 03:17 PM
I cant work out how to have the out time show beside he in-time
Appreciate any suggestions
thanks db