Access keeps "untidying" my SQL

  • Thread starter Thread starter mr-tom
  • Start date Start date
M

mr-tom

Hi all,

I'm getting to grips with SQL (within Access 2002) but am finding the SQL
view to be a bit of a pain.

Each time I quit and go back it, Access has messed up all my SQL, removing
indents, line breaks etc.

Is there any way around this? (Other than reformatting it each and every
time I go into it) Otherwise it makes it all a bit incomprehensible.

Any suggestions very gratefully received.

Cheers,

Tom.
 
I keep a parallel copy of sql in notes/word while I'm tweaking...where I can
give it the visual structure I need to help keep my mind straight....

then copy/paste it into sqlview and test it

b.t.w. if you build an sql & run it via vba it will keep your layout...
 
Never, ever save the query in the QBE design view. Alway save it in SQL view.
Try to avoid even looking at it in QBE.

And also do as GBA suggests.
 
Back
Top