How to write comment in Ms Access SQL view?

Posted on 2005-04-04
Medium Priority
Last Modified: 2008-02-01

How to write comment in Ms Access SQL view?
Let say I want to write comment in front of the SQL statement like:
Comment: This statement is used to extract data from...
in MS SQL Server, by adding the symbol -- infront of the comment.
In MS Access, what symbol is being used for the comment?
Question by:Cola78
  • 2
LVL 53

Expert Comment

ID: 13695619
You cant add comments to your query in the SQL view of your query (from the grid).
However, you can add comments in VBA code, using the ' .
LVL 53

Accepted Solution

Dhaest earned 80 total points
ID: 13695629
You can add comment to the query by selecting the query under the query-tab of the database window and press properties. (button or via right-click)
This comment is also visible when selecting the 'detail' view of the queries.

However it's not possible to store the comment "in" the query as far as I know.

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question