Comments in Access SQL

L

Littlemalky

Board Regular
Joined
Jan 14, 2011
Messages
223
Hi, is there a way to add comments into my union query's SQL so I know what each query is exactly?
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
Sort by date Sort by votes
If vba, then yes, simply preface the comment with an apostrophe. If in query sql alone, then AFAIK, no. But you can enter notes into the query properties dialog. Right click on the query in Nav pane. Available for other pane objects as well.
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
MS Query and Access Union Query
2 3
Replies
28
Views
915
mdmilner
M
Anigito
  • Solved
MS Access Union Query Changes Numeric values to Text values
2
Replies
11
Views
846
Anigito
Anigito
S
  • Question
ACCESS, VBA: Fetch data from sql server and paste it into local table.
Replies
3
Views
803
Micron
M
starl
  • Solved
Need help reformatting imported fields
Replies
2
Views
210
welshgasman
welshgasman
C
  • Question
VBA code for Next button to move to each record in Textbox1
Replies
2
Views
193
welshgasman
welshgasman

Forum statistics

Threads
1,214,932
Messages
6,122,323
Members
449,077
Latest member
jmsotelo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top