MS Access Query:   How to uncomment?

Posted on 2009-04-18
Last Modified: 2012-05-06
Dear Experts:


I would like to learn how to uncomment a few lines in a query statement in MS Access 2007.

Thanks a lot!
Question by:duta
    LVL 65

    Expert Comment

    do you mean query statement developed in vba?

    Author Comment

    Genius, I mean Query statement ( Select sum (emp_Sal ) from employee where Hire_Date > '#05/1/2008#')
    in MS Access, not in VBA.

    LVL 65

    Expert Comment

    so what do u mean by uncomment?

    u dont need quotes around the date though

    Select sum (emp_Sal ) from employee where Hire_Date > #05/1/2008#


    Author Comment

    I created a report using over a hundred of lines of queries.

    I thought it would be very convenient to uncomment some lines, instead of deleting them, because often times I needed to restore the deleted lines.

    Thanks, Genius!
    LVL 65

    Accepted Solution

    You mean comment lines

    There is no concept of adding comments in queries in msaccess, if you right click on a query though and select properties, you can enter something in the description (max 255 chars I think)

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now