• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

MS Access Query: How to uncomment?

Dear Experts:

Hi!

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

Thanks a lot!
0
duta
Asked:
duta
  • 3
  • 2
1 Solution
 
rockiroadsCommented:
do you mean query statement developed in vba?
0
 
dutaAuthor Commented:
Genius, I mean Query statement ( Select sum (emp_Sal ) from employee where Hire_Date > '#05/1/2008#')
in MS Access, not in VBA.


query-in-ms-access.png
0
 
rockiroadsCommented:
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#

0
 
dutaAuthor Commented:
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!
0
 
rockiroadsCommented:
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)
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now