How do I add an inline comment to an SQL query?

[Mark Allan Nelson]

I'm trying to find out how to enter inline comments in a query. For example,
If I:
1) click on "Queries" under "Objects".
2) Click on "Create query in Design view".
3) Under the "Tables" tab, click MyTable.
4) Click the "Add" button.
5) Click the "Close" button.
6) Drag the the "*" to the first field.
7) Click "View".
8) Click "SQL View".
I will see:
SELECT MyTable.*
FROM MyTable;

I want to ad something like:
/* My comment */
SELECT MyTable.*
FROM MyTable;

I tried:
//
'
--
#
{}
SQL-comment
C-comment

I know how to add a comment in the description property, but inline comments
would really help me. Does anyone have any suggestions?

Thanks,
Mark Nelson

 

[Lynn Trapp]

Mark,
You and about 10,000 other Access developers would like to have that
functionality, but it is not available.

 

[Jeff Conrad]

I haven't tested this myself, but I thought Sensei Lebans has something here to accomplish that
task:

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

 

[david epsom dot com dot au]

Or,

SELECT MyTable.*,"my table contains my data" as myComment
FROM MyTable;


Mostly just irritating, but sometimes it's actually useful
to have your comments come out as a query field:

SELECT Myquery1.*,"MyQuery2," & MyQuery1.MyComment as myComment
FROM Myquery1;

(david)

 

[Lynn Trapp]

I've seen that too but haven't had time to try it out.