Hi all
ms Access 2003, SP2.
I write a SQL statement that unions some other queries and it works
ok. Then, if I save and close it and open the form that uses the query
as its data source, I get an error that the form can't find some parts
of the SQL that was in my query. I open the query again and find that
Access has changed my SQL, removing some of my code.
Whats up with that?
Is there some way to tell Access to leave my SQL code alone, it works
just fine as I wrote it?
Thanks
Jeff