Comments in Access SQL

[Littlemalky]

Hi, is there a way to add comments into my union query's SQL so I know what each query is exactly?

 

[Micron]

If vba, then yes, simply preface the comment with an apostrophe. If in query sql alone, then AFAIK, no. But you can enter notes into the query properties dialog. Right click on the query in Nav pane. Available for other pane objects as well.