Skip to Content
0
May 28, 2020 at 01:06 AM

Filter by most recent & exclude if field = x

46 Views

I'm trying to create a report that will show who is checked in and eliminate who has checked out.

People are identified with a field called memid.

The scan date & time are in a field called checkin.

Scan stations are in a field called stationid.

There are 2 check-in stationid's: 52 and 187

There is 1 check-out stationid: 192

There is 1 stationid that can be ignored (it's a secondary station further within the building): 56

How do I get the result that shows only those who have checked in today and their most recently scanned stationid is not 192 (who is currently checked in)?