Comments in SQL

[paii, Ron]

Is there a way to add comments to a Access SQL string. For example between
UNION to comment on what data each UNION is adding.

[Rich P]

I have been able to add comments in the Query Sql window by adding a
single quote ' and comments after that -- after the sql for the query

Select * from tblA
Union All
Select * from tblB
' comments -- tblA old data -- tblb new data

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[paii, Ron]

"Rich P" <rp*****@aol.comwrote in message
news:47*********************@news.qwest.net...

I have been able to add comments in the Query Sql window by adding a
single quote ' and comments after that -- after the sql for the query

Select * from tblA
Union All
Select * from tblB
' comments -- tblA old data -- tblb new data

Rich

*** Sent via Developersdex http://www.developersdex.com?wp_ml=0 ***

Thanks Rich

Single quote did not work in Access97.

[Rick Brandt]

paii, Ron wrote:

Single quote did not work in Access97.

Access queries do not support comments unless they are passthrough queries
to a server databse that does support them.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[John Mishefske]

paii, Ron wrote:

Is there a way to add comments to a Access SQL string. For example between
UNION to comment on what data each UNION is adding.

Stephen Lebans has an interesting approach to this problem:

http://www.lebans.com/addsqlcomments.htm
--
'--------------------------
' John Mishefske
' UtterAccess Editor
' 2007 Microsoft MVP
'--------------------------