Comments

A

anonymous

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

TIA
 
J

John Spencer (MVP)

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.
 
A

anonymous

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.


.
 

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

Top