When the query open in design view, open the properties of the query (press
Alt+Enter or view > properties), and add a description in the description
part.
Access can't add comments to the text of the query (SQL). You can add
comments to the query object. Right click on the query object in the
database window, select Properties. Enter comments in the description
field.
Access can't add comments to the text of the query (SQL). You can add
comments to the query object. Right click on the query object in the
database window, select Properties. Enter comments in the description
field.
You can also add comments to query fields, in Design View, by
right-clicking on the field column (or using shift-F10, or using View
--> Properties) and entering text in the Properties field of the pop-up
menu. As with a Table, when that field is selected in Datasheet View,
your comment will appear in the status line at the bottom of the window.
This can give a fuller explanation of the field's intended use than
its name does.
-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
