Can you 'commnet out' in Access 2000 SQL?

[Gaijintendo]

I have tried // and '...

 

[KARL DEWEY]

I use a calculated field for comments like this -- "Now is the time for..."
AS [X],

 

[Terry]

Can a comment be put into Access SQL code? If it can, what format will be
valid?

 

[Banana]

Can a comment be put into Access SQL code? If it can, what format will be
valid?

There are no support for comments in Access SQL code. Sorry.

The closest thing you could do is use Description property (a custom DAO
property that you would create/append, actually). You also can set it
from GUI and in Access 2003 & earlier, sort queries by the Description
property.

But if you're trying to insert MySQL code, then you're probably better
off using PTQ, without the comment anyway.

 

[Dirk Goldgar]

Can a comment be put into Access SQL code? If it can, what format will be
valid?

Not in any normal way. Wizard Stephen Lebans did create a method to do it:

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

.... using Windows API methods and a special table to hold the comments
separately from the querydef, but it's extremely elaborate and has always
seemed like more trouble than it's worth, to me.

 

[hoarau sébastien]

vous parler tous anglais ou koi

Can a comment be put into Access SQL code? If it can, what format will be
valid?

 

[John W. Vinson]

vous parler tous anglais ou koi

Il s'agit d'un groupe de soutien technique pour le programme Microsoft Access.
Sa langue officielle est l'anglais. Pour un groupe français, voir
microsoft.fr.public.access.

 

[De Jager]

Can a comment be put into Access SQL code? If it can, what format will be
valid?

 

[De Jager]

Can a comment be put into Access SQL code? If it can, what format will be
valid?

 

[david]

Also, remember that you can add expressions to your SQL:

SELECT MB_Error_Codes.idx
, "2010/03/15 dlg"
FROM MB_Error_Codes;

(david)