The following should clearly outline the problem query output as well as the desired query output:
Access 365 Query Issue.JPG