Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-13-2019, 12:57 AM   #1
Jonny
Newly Registered User
 
Join Date: Aug 2005
Posts: 136
Thanks: 76
Thanked 0 Times in 0 Posts
Jonny is on a distinguished road
Commenting within the queries

I'm getting lost due to multiple criterias within the queries. What's the best practice to comment the criterias?

Jonny is offline   Reply With Quote
Old 08-13-2019, 01:22 AM   #2
arnelgp
error reading drive A:
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 8,568
Thanks: 68
Thanked 2,744 Times in 2,629 Posts
arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice arnelgp is just really nice
Re: Commenting within the queries

put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
The Following User Says Thank You to arnelgp For This Useful Post:
Jonny (08-13-2019)
Old 08-13-2019, 01:38 AM   #3
Jonny
Newly Registered User
 
Join Date: Aug 2005
Posts: 136
Thanks: 76
Thanked 0 Times in 0 Posts
Jonny is on a distinguished road
Re: Commenting within the queries

Quote:
Originally Posted by arnelgp View Post
put in a Table the query name, SQL string, criteria, comment
there is no facility to add comment on the query itself.
Good idea, thank you!

Jonny is offline   Reply With Quote
Old 08-13-2019, 01:44 AM   #4
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,974
Thanks: 114
Thanked 3,002 Times in 2,729 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Commenting within the queries

Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.



To add a description, click the object in the nav pane and select Object Properties from its context menu.
Attached Images
File Type: png Capture.PNG (29.1 KB, 40 views)
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Jonny (08-13-2019)
Old 08-13-2019, 02:18 AM   #5
Jonny
Newly Registered User
 
Join Date: Aug 2005
Posts: 136
Thanks: 76
Thanked 0 Times in 0 Posts
Jonny is on a distinguished road
Re: Commenting within the queries

Quote:
Originally Posted by isladogs View Post
Alternatively, you can add a comment/description to any database object such as a query which can be viewed when you use Details view in the navigation pane.



To add a description, click the object in the nav pane and select Object Properties from its context menu.
Great, thank you!
Jonny is offline   Reply With Quote
Old 08-13-2019, 03:32 AM   #6
isladogs
High Noon Moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,974
Thanks: 114
Thanked 3,002 Times in 2,729 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Commenting within the queries

You're welcome

__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin (Mendip Data Systems)
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


"As we know, there are known knowns; there are things we know we know. We also know there are known unknowns; that is to say we know there are some things we do not know. But there are also unknown unknowns the ones we don't know we don't know. It is the latter category that tend to be the difficult ones" Donald Rumsfeld
isladogs is offline   Reply With Quote
The Following User Says Thank You to isladogs For This Useful Post:
Jonny (08-13-2019)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Commenting in a SQL command CasitaProgrammer Queries 2 04-06-2011 12:16 PM
Commenting Out Lines of Code ddrew General 2 12-17-2010 01:58 AM
Commenting out SQL Codes in Access oscarooko Queries 2 01-18-2006 06:34 PM
can commenting be done in access queries spec Queries 1 08-29-2005 02:54 AM
Commenting Code poet1234 Modules & VBA 3 10-29-2004 10:14 AM




All times are GMT -8. The time now is 01:27 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World