duta
asked on
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!
Hi!
I would like to learn how to uncomment a few lines in a query statement in MS Access 2007.
Thanks a lot!
do you mean query statement developed in vba?
ASKER
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
in MS Access, not in VBA.
query-in-ms-access.png
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#
u dont need quotes around the date though
Select sum (emp_Sal ) from employee where Hire_Date > #05/1/2008#
ASKER
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.