How to stop extra parenthesises

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Is there any way to prevent Access from adding extra parenthesises and
brackets([]) in the queries? Thanks.

Ben

--
 
Why would you not want Access to clean up the typing for you? The query
results are the same aren't they?
 
Dear Ben:

When you write a query, save a copy of the query using Notepad. It will
always be there for you to perform future work. When you're ready, past the
new SQL into the SQL View and run it.

Access mangles your queries in ways you cannot control. I have lobbied for
an option to have it not do this. No luck so far.

Sorry!

Tom Ellison
 
It's just hard to look at when I have to debug or review it 3 months later.
Thanks.

Ben

--



Rick B said:
Why would you not want Access to clean up the typing for you? The query
results are the same aren't they?



--
Rick B



Ben said:
Hi all,

Is there any way to prevent Access from adding extra parenthesises and
brackets([]) in the queries? Thanks.

Ben
Click to expand...
Click to expand...
 
Thanks Tom. That is exactly what I have resorted to do. I am saving it in a
module.

Ben


--



Tom Ellison said:
Dear Ben:

When you write a query, save a copy of the query using Notepad. It will
always be there for you to perform future work. When you're ready, past the
new SQL into the SQL View and run it.

Access mangles your queries in ways you cannot control. I have lobbied for
an option to have it not do this. No luck so far.

Sorry!

Tom Ellison


Ben said:
Hi all,

Is there any way to prevent Access from adding extra parenthesises and
brackets([]) in the queries? Thanks.

Ben
Click to expand...
Click to expand...
 
Back
Top