The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
-Access Product Team
An error occurred while saving the commentRaymondC commented
Complicated queries with multiple outer joins often require sub-queries. While this can be done in the SQL window, it would be nice if there was a way to do this in the designer window.
It would also be nice if you could create SQL Server pass-through queries in the designer window and not just manually in the SQL window (or in code).