SQL comments

[Guest]

Hi,

I am wondering if anyone knows how to put comments in the SQL statements
within Access queries. The usual syntax is '--' in the beginning of the line,
but that doesn't seem to work in Access.

Thanks.

 

[Allen Browne]

Access does not permit comments in the SQL text.

Add your comments to the Description property of the query.

Alternative:
http://www.lebans.com/addsqlcomments.htm