Comment in SQL Statement

Peter · Apr 25, 2005

I am new to MS Access and would like to know how to add comment in the SQL
Statement ?

I have tried the following but seems they don't work:
'
//
/*

Marshall Barton · Apr 25, 2005

Peter said:
I am new to MS Access and would like to know how to add comment in the SQL
Statement ?

No such thing, yet.

It's a common request, among other, for query design.

If it's important, take a look at a module that does that:
http://www.lebans.com/addsqlcomments.htm

Sylvain Lafontaine · Apr 25, 2005

For all I know, you can't.

Rob Parker · Apr 25, 2005

You can put comments into the Description field of a saved query
(right-click on the query, and select "Properties" to access the field).
Other than that ... nothing that I know of.

HTH,

Rob

Comment Lines in MS Access SQL	3	Aug 17, 2007
Subquery with Select Substring	1	Jun 23, 2011
Modifying subform's underlying SQL statement	2	Nov 6, 2009
Comment in Union Query	1	Aug 3, 2007
How do I execute multiple SQL statements in Access??	3	Mar 13, 2010
Syntax to enter comments in the SQL SELECT statement ?	1	Dec 7, 2005
Calling Parameterized Query Using SQL Syntax	3	Nov 17, 2010
If ActiveCell has a comment then exit sub	22	Jan 13, 2015

Comment in SQL Statement

Peter

Marshall Barton

Sylvain Lafontaine

Rob Parker

Ask a Question

Similar Threads