How to make notes for a query

[Tod]

I need a handy trick for this.

When I'm creating queries, I want to keep track of why I
did what I did, what the criteria mean, etc. In VBA I can
have a comment field. In Excel I can create a comment box.
Is there something similar available for Access queries. I
know I can just make notes (hand scribbled or typed), but
it would be so much better if I could easily associate my
notes inside the query.

Any ideas?

tod

 

[John Vinson]

Is there something similar available for Access queries.

Alas, no, unless you use VBA to create a custom property for the query
(and go to a rather large amount of hassle to update that property).

 

[John Viescas]

Tod-

Use the Description property. Right-click the query, choose Properties,
type in the description, and click OK. You'll see the description when you
have the Database window in Details view.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)