Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dumb Documentation Question (2000)

    Is there any simple way to document queries. I have a very complex database (complex because the outside data source has lost the plot a bit on standardisation). What would be ideal is that for each calculated column on a query, I could document what that particular section of the query is doing eg what the data source is, what the calculation is doing and what exceptions apply as part of the query itself. The comment section in properties is too short
    TIA
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Dumb Documentation Question (2000)

    You can't write long explanations in the description properties, but you can enter brief descriptions for the query itself and for each field separately. Another approach is to save your explanations in a special table in the database. You can save the query name in a text field and the description in a memo field and even include the SQL in another field if you want. If you can't document the query in a single memo field, it is probably too complicated! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  4. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Now-Luanda, Angola, Originally - Anna Bay, New South Wales, Australia
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dumb Documentation Question (2000)

    Thanks for the quick response - exactly where can I enter brief descriptions "for each field separately"
    Dummy from Down Under <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,517
    Thanks
    0
    Thanked 22 Times in 22 Posts

    Re: Dumb Documentation Question (2000)

    Just right click on the field you want to add a comment for and select Properties, then just enter into the Description field.
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •