Commenting SQL Code In-Line

[psimpson]

Is there a way to comment out a specific section of a SQL query within MS Access? The normal SQL commands such as, rem text; ' text ; - text ; or /* text doesn't seem to work.

Any help is appreciated.

Thanks.

 

[Uncle Gizmo]

You could build the string up In a function and run the SQL statement from a function.

Alternatively I do know of a product you can buy that allows you to comment your SQL code, keeps a history of edits and stores the SQL for you. MORE HERE

 

[psimpson]

Thanks for the confirmation, additional information.

 

[Heywood43]

Nice tool. I like how it retains formatting of your SQL also.

I always cringe whenever I see my nicely formatted SQL get turned into a stream of text the next time I open it up. I wonder why Microsoft doesn't have this type of functionality out of the box.