Commenting SQL Queries

I'm a summer-hire writing databases for my employer. I have the slight problem that no-one in my group knows anything about Access and I'll be leaving in 3 weeks. I'd like to document what's going on in a SQL query I just modified, but Access doesn't recognize two hyphens "--" or an apostrophe " ' ".

Please tell me I can add comments to SQL code, or I'll have a lynch mob after me once I return to school.

"Kyle B." wrote in message

I'm a summer-hire writing databases for my employer. I have the
slight problem that no-one in my group knows anything about Access
and I'll be leaving in 3 weeks. I'd like to document what's going on
in a SQL query I just modified, but Access doesn't recognize two
hyphens "--" or an apostrophe " ' ".

Please tell me I can add comments to SQL code, or I'll have a lynch
mob after me once I return to school.

Better start running, Kyle. You can't add comments to SQL code in
Access. Well, actually, Stephen Lebans has found a clever workaround,
but it's rather elaborate. Have a look he

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Thanks Dirk, I was affraid of that. Skimming through the link you sent, I think I'd be better off not trying to explain that I have a script that is used to move coments in and out of the SQL code. That, and I'm sure someone would find a way to hose it up. I'll resort to the binder full of printouts with lots of handwritten notes. ... If I have time... g

Happy weekend,
Kyle

"Dirk Goldgar" wrote:

"Kyle B." wrote in message

I'm a summer-hire writing databases for my employer. I have the
slight problem that no-one in my group knows anything about Access
and I'll be leaving in 3 weeks. I'd like to document what's going on
in a SQL query I just modified, but Access doesn't recognize two
hyphens "--" or an apostrophe " ' ".

Please tell me I can add comments to SQL code, or I'll have a lynch
mob after me once I return to school.

Better start running, Kyle. You can't add comments to SQL code in
Access. Well, actually, Stephen Lebans has found a clever workaround,
but it's rather elaborate. Have a look he

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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)