I’m encountering an issue in MS Access with a subquery that works perfectly as a standalone query. Here