Search results

here's the data

thank you so much just one more thing how to define in zzQuery2 in=1 and out=2 to be a variable? because 1 maybe be 1 and 3 and 5 (3 entry - 3 doors in) or all tree data, and out maybe 2 and 4 an 6 (3 out data-3 door out)? in: IIf([event_point_id]=1;[time];Null) out...

bravo thats is perfect, thanks a lot just one detail how to correct chkOUT() function to take first record on the way out and not the last one?

A: tables acc_monitor_log id time card_no event_point_id 32 28.4.2020. 13:01:04 13751793 2 37 28.4.2020. 13:19:17 13751793 2 38 28.4.2020. 13:19:22 13751793 1 43 28.4.2020. 13:26:57 13751793 2 5 28.4.2020. 13:26:57...

I don't think we understand each other, let's ask a more specific question: How in this query should i throw out times data that are similar , times that have differences greater than 20 seconds ? example: time1: 28.4.2020. 13:51:23 time2: 28.4.2020. 13:51:24 time3: 28.4.2020. 13:51:35 time4...

Yes, but how to catch errors, because i don't have that information in the database?

No, I was think about all items that have incorrect information. All the items that have a description of the error to throw them out of the query as in the picture below. I mean, for example, if there is no IN and there is an OUT, that item is mistaken and is eject from the report.

Thank you for quick reply Yes, but how to throw out items from table that are incorrect? Example from previous post: no_in , no_out, double_in

Ok. I gave you an example of the previous table, but here's an example with the exact data in the table.

Hello, good day I'd would like to do the calculation as in the picture in attacment but there would be more entrances and exits in one working day E.g: Item1. IN 30.04.2020 13:21:10 - OUT 30.04.2020 14:10:32 - WORKING TIME 00:49 Item2. IN 30.04.2020 14:29:15 - OUT 30.04.2020 14:34:40 -...

I need a calculation of the time spent in a room. I have eg 2 or more entrances and so many exits to and from a room. I have an access controller at each door both at the entrance and at the exit in both directions (defined in the event_point_id field. So I have a record of each entry and exit...