Quantcast

Access question

J

JRB

Guest
Does anyone know if I can comment out select criteria in a query without deleting it???
 
J

JRB

Guest
Not even if I edit the SQL??? That seems silly. Every other query lets you doesn't it???

Not to be lazy, but I have a form parameter I don't want to get hosed up.
 

dropkick

Chimp
Jul 3, 2004
76
0
Colorado
There are a couple things you can do -
Copy/paste the original sql into the query description(right click the query > properties), then if you make some changes and something doesn't work you still have an original copy to fall back on.

You can also run the query from VB - just copy the sql to a string and comment out whatever you need.
 
J

JRB

Guest
dropkick said:
There are a couple things you can do -
Copy/paste the original sql into the query description(right click the query > properties), then if you make some changes and something doesn't work you still have an original copy to fall back on.

You can also run the query from VB - just copy the sql to a string and comment out whatever you need.

I kind of figured the copy was my next bet. I may screw it up with VB. :think:

Oh - and thanks.