Ronald_yoh
04-07-2008, 03:56 PM
Anyone knows how to turn off the auto correction for query.
I have a subquery as follow:
select t1.customerid
from (select customerid from tblcust group by Custid having count(*) = 1) t1 inner join tblOrder on tblOrder.customerid = t1.customerid;
The above query works if you excute directly but when you save the above query, stupid ms access will auto correct it as follow:
select t1.customerid
from [select customerid from tblcust group by Custid having count(*) = 1]. as t1 inner join tblOrder on tblOrder.customerid = t1.customerid;
when you have the above format, you just are not able to execute it but you can't open it in design view..
Any ideas guys?
cheers
R
I have a subquery as follow:
select t1.customerid
from (select customerid from tblcust group by Custid having count(*) = 1) t1 inner join tblOrder on tblOrder.customerid = t1.customerid;
The above query works if you excute directly but when you save the above query, stupid ms access will auto correct it as follow:
select t1.customerid
from [select customerid from tblcust group by Custid having count(*) = 1]. as t1 inner join tblOrder on tblOrder.customerid = t1.customerid;
when you have the above format, you just are not able to execute it but you can't open it in design view..
Any ideas guys?
cheers
R