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)?