Your data doesn't allow you to absolutely identify if a record is check in or check out, so you can't create this output. If someone forgets to check out, your data will be useless if you rely solely on the records following on from each other
You really need a field to record the type of time record being recorded.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Yes, either a type field then query that pulls data from another record - review: http://allenbrowne.com/subquery-01.html#AnotherRecord
Or have In and Out fields horizontal. My employer has time sheet designed with StartIn LunchOut LunchIn EndOut fields. Normally 1 record for each day. Although holidays worked and shifts crossing midnight cause multi-line days. I don't know the database platform nor the code, but I suspect is something much more sophisticated than Access/VBA, especially since it is web-based entry.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi
I do agree with your point of view and its valid argument. There is another field of "checktimetype" like "I" for timein and "0" for timeout but normally workers dont do select this option and just punched at exit or entry and this can be reverse case when night shift punched in at 17:00 and next day leave at 07:00.
So lets say we can change field heads like that" CheckTimeA" & CheckTimeB" at that specific day whereas in night shift one entry would be missing at day one.
So at least this should be in available in the desired format as table two.
*May we can have another solution to assign the shifts for workers which are change over month end basis which could guide for the time sheet.
hope to hear from you
Hi
Thanks for the input information.
You are right and in general the format is the same in most of the org. In our case, we do have two entries only just IN & OUT and no another entry would be accepted around the 24 hours time. This is how the bio metric machines provided.
So the only the concern is to get the specific above table information.
you still don't have enough data - if the rule is 'check in is the first check in of the day' you can determine first with a query
SELECT EMPID, DATED, Min(CheckTime) AS CheckIn
FROM tblBio
WHERE
GROUP BY EMPID, DATED
However this won't work for the night shift, so you need another field to indicate which shift the employee is on
So when is 'day one' - how do you identify when a shift pattern started?So lets say we can change field heads like that" CheckTimeA" & CheckTimeB" at that specific day whereas in night shift one entry would be missing at day one.
Hi, Thanks for the efforts.
I do agree with you.
So what do you think if to have an another real way out in which every month shifts are assigned to employees. a group of employees are given day shift and others night shift and by last day of month or last weeked its changed vice versa.
Then is it possible to control the entries even if they punch without selecting the in/out in biometeric machine?
Kindly advise?
probably would work, but sounds too restrictive to meet real life requirements - what if someone swaps shifts? does a double shift? Really sounds like you need to train your employees to use the machine properly or change the machine for one that actually does what you want