Access keeps "untidying" my SQL

[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.

 

[GBA]

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...

 

[Jerry Whittle]

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.

 

[mr-tom]

Thanks both of you - I'll def. be doing all of these - good learning points!