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.

"tom" <(E-Mail Removed)> wrote in message
<5I65h.488$(E-Mail Removed)>:
> 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.

--
Roy-Vidar

"tom" <(E-Mail Removed)> wrote:

>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
--
www.kcc.ch

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"tom" <(E-Mail Removed)> wrote in message
news:5I65h.488$(E-Mail Removed)...
> 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.
>

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

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

--
HTH
Van T. Dinh
MVP (Access)



"tom" <(E-Mail Removed)> wrote in message
news:5I65h.488$(E-Mail Removed)...
> 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.
>

On Fri, 10 Nov 2006 22:04:49 GMT, "tom" <(E-Mail Removed)>
wrote:

>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]

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.

--
Bill Mosca, MS Access MVP


"Van T. Dinh" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I haven't tried Stephen Lebans "addsqlcomments" but here it is:
>
> http://www.lebans.com/addsqlcomments.htm
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "tom" <(E-Mail Removed)> wrote in message
> news:5I65h.488$(E-Mail Removed)...
>> 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.
>>
>
>