Good day all,
I have a query from a table with fields "OfficerName" and "SignInTime". I want to return a single record for any particular officer containing their earliest time for the day.
I enter the officer's name in as part of the criteria and in the SinginTime I enter Min(SignIntime) but this give an error message.
Can anyone give some suggestions as to what to enter to get the desired results?