Comments in queries

[Jonathan]

Is there a way to put comment lines in in an Access query? e.g.

;Comment
;Comment
SELECT ...
;Comment

Thanks,
Jonathan

 

[Dirk Goldgar]

Is there a way to put comment lines in in an Access query? e.g.

;Comment
;Comment
SELECT ...
;Comment

There's no built-in way, and I really wish there were. Stephen Lebans
has worked his usual deep magic to create a way to save and present
comments in the SQL view window, though. I haven't used it, but you'll
find it here:

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

 

[Guest]

Hummm... I do it all the time with PL/SQL and Oracle. Something like below
works there:

SELECT * /* comment
goes here */
FROM pers;
or
SELECT * --comment goes here
FROM pers;

No joy in Access. I even tried the single quote ' but that didn't work.

Good question! Hopefully someone has a matching good answer.

 

[Roger Carlson]

Dang! I wish I knew how Stephen comes up with this stuff!

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L