Comments

  • Thread starter Thread starter anonymous
  • Start date Start date
A

anonymous

The /* does not allow comments in my ACCESS SQL
statement, why is this? How does one add comments
in ACCESS SQL.

TIA
 
One doesn't. Access SQL does not support comments. Wish it did.

Workarounds:
Store the SQl statements in a word document, where you can append comments.
Store the SQL statement in a memo field in a table along with another field
where you can put comments.
Store the SQL string as code in a module and then call/use the module to execute
the SQL.

All are not very satisfactory.
 
Thanks...
-----Original Message-----
One doesn't. Access SQL does not support comments. Wish it did.

Workarounds:
Store the SQl statements in a word document, where you can append comments.
Store the SQL statement in a memo field in a table along with another field
where you can put comments.
Store the SQL string as code in a module and then call/use the module to execute
the SQL.

All are not very satisfactory.


.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comment Lines in MS Access SQL 3
Subquery with Select Substring 1
Commenting in SQL 3
Dcoumenting your SQL code? 0
inline sql comments in access 2007 ? 8
Word to Excel: Export comments with text and line number 0
How can I add a comment in a query in Access? 4
SQL comments 1

Back
Top