Commenting SQL code in Union query

[tom]

How to comment SQL code in a Union Query or
any query for that matter.

I tried help but couldnt seem to find the answer to this
one.

 

[RoyVidar]

How to comment SQL code in a Union Query or
any query for that matter.

I tried help but couldnt seem to find the answer to this
one.

As far as I know that isn't possible with Access queries, except for
right clicking the query in the database window, select properties,
and "document" in the description property.

 

[Matthias Klaey]

How to comment SQL code in a Union Query or
any query for that matter.

I tried help but couldnt seem to find the answer to this
one.

AFAIK there is no way to put comments into the SQL code for any Access
query. The only possibility I see ist to use the Description Property
of the query. For passtrough queries, the server rules should apply,
so it may be possible to include comments.

HTH
Matthias Kläy

 

[Arvin Meyer [MVP]]

There really isn't a good way to comment a JET query, but here is a possible
work-around:

Open a table or query's property sheet and type your comments in the
Description property. In the query QBE grid, you can also select a column
and use its Description property. Union queries do not have the QBE grid,
but I always take the constituent parts and save them as separate queries,
like:

qryUnionMain
qryUnionMain1
qryUnionMain2

 

[Van T. Dinh]

I haven't tried Stephen Lebans "addsqlcomments" but here it is:

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

 

[John Vinson]

How to comment SQL code in a Union Query or
any query for that matter.

I tried help but couldnt seem to find the answer to this
one.

That's because comments are not supported in JET queries.

The only way is to put in a calculated field containing the comment.

John W. Vinson[MVP]

 

[Bill Mosca, MS Access MVP]

Stephen method works quite nicely, but I would rather copy the SQL into a
text file and comment it as though it were an MS SQL Server view or proc.
That way you can write inline comments. You could even store all of the text
file in a table, but keeping up with changes would be a bear.

Maybe someday, Access will accept comments in queries.