I need some assistance with an access query. I have a table, and there are 2 fields of interest, for now lets say Field9 (activity) and Field1 (date). the rows of data represent login activity to an application. The entries in Field9 can be either In, Out, Screensaver, Locked, Unlocked. What I need to do is to group on Field1 (date), to get a list of unique dates where none of the rows for that date contain the word Locked.
E.g. from this data:
the query would return both 25/09/2018 and 27/09/2018 , as on both of those days, there was no locked entry in any of the rows for those dates, whereas for 26/09/2018 there was. Not sure what approach to use, I did think of group by count as a basis and manual filter of those results.