sub-query

[QB]

Is there a reason my when I code a sub-query and test it, it runs fine. When
I reoprn the SQL, access has added AS Alias.... I then close and save it.

What is strange is in certain instances, still trying to find a patern,
after saving what was a functional query, when I try to rerun it I get an
error

'Invalid bracketing of name ...'

Is this something I am doing wrong or is there something I need to learn
about creating sub-queries to avoid this issue?

Thank you,

QB

 

[Jerry Whittle]

Access tries to re-write sql statements to run more efficiently. Every once
in a while, it gets it wrong.

Next time when you create this query, do it in SQL view and save it there.
Try your best to never run, save, or make changes to it while in QBE Design
view.