Syntax used to add a comment in a SQL query in Access 2003

[Guest]

Hello,

Can anyone provide me with the correct syntax to add a comment line to a
query written in SQL language ni Access 2003. I have tried a single quote,
Asterick and forward slash but nothing seems to work. Thanks.

 

[Brendan Reynolds]

Jet SQL does not support comments.

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You can't put comments in an Access query's SQL view. If you want you
can put a comment in the QueryDef's Description. How?

1) highlight the query
2) right click & select Properties
3) Type in the comments in the Description field

If your query is an SQL Pass Through (SPT) query you can use double
dashes (--) per line of comment or start, end comment symbols of
/* <comment> */.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQkCHRIechKqOuFEgEQKBKACeJd/mm6gqDIF6S4yC5sZBnoWtizcAoLp2
pnIprbeydTxtOvqzyL2B8CTd
=KUoi
-----END PGP SIGNATURE-----