I assume your date/time is one field, and it is called [Date Time]. You
would not want to name fields [Date] or [Time] in Access.
If you want to know which users are IN, they are the ones that have an odd
number of records. This assumes the data is clean, and you would not have
two 'IN' records without at least one of them having a matching 'OUT' record.
To do this, write one query containing the [User] and the [Date Time]
field. Using the Totals, 'Group by' the User, and 'Count' the Time Field.
Save this query.
Then make a second query based on the first query containing the User field
and another field containing the following ([CountOfDate Time] is the
default name from the first query unless you provided an alternate name):
[CountOfDate Time]/2-Int([CountOfDate Time]/2)
Since there isn't a 'Mod' function in Access, this will return a 0 for
records with an even count (these are 'OUT') and 0.5 for users with an add
count ('IN'). To restrict your query to pull only those that are IN, put
criteria below this expression field as follows:
Between 0.4 And 0.6
For a simple count, use the Totals, and 'Group by' the user field and set
the second field as an 'Expression'. You don't need to show this second
field.
Hope that is what you are looking for.