(It’s weird that I visit the board for the first time in days to ask a question about Microsoft Access and the first thread is… a question about Access. But anyway.)
When constructing a query in SQL in Access, is there any way to add comments? I’ve tried double hyphens (–), braces ({}) and backslash-asterisk (/*) but they all create syntax errors.
If you are writing a SQL query in the QBE query builder, there is no way to comment it. If you are using VB or VBA, then you can comment the code the same way that you would comment any other VB code.
[QUOTE=SanibelManWhen constructing a query in SQL in Access, is there any way to add comments? I’ve tried double hyphens (–), braces ({}) and backslash-asterisk (/*) but they all create syntax errors.[/QUOTE]
The only way I know of is if you save your query you can then right-click on the query in Queries tab / pane and then enter a description.