how to comment sentence in sql query - in access 2007 ?

Question

hi

how to comment sentence in sql query - in access 2007 ?

thank's in advance

Answer 1

According to this, you can't comment SQL code. To comment VBA code use a single quote (').

Answer 2

If you're not trying to place a remark on a specific line of the code, but for the overall query, you can enter it in the Description under the query properties.

Answer 3

Here's one way:

SELECT query_comment_goes_here 
       (SELECT * FROM Employees WHERE 1 = 0), 
       O1.OrderID, O1.CustomerID, O1.OrderDate 
  FROM Orders AS O1;