The disappearing SQL

[scubadiver]

I have a query that contains a subquery and when I try to open the query
after closing the form that contains the query, the SQL disappears.

Anyone come across this before?

 

[Stefan Hoffmann]

hi,

I have a query that contains a subquery and when I try to open the query
after closing the form that contains the query, the SQL disappears.

Anyone come across this before?

Yup. For example

SELECT *
FROM
(subquery) Q

will be stored as

SELECT *
FROM
[subquery] AS Q

Sometimes this leads to confusion (of Access.


mfG
--> stefan <--

 

[scubadiver]

that is useful to know.

thanks

hi,

I have a query that contains a subquery and when I try to open the query
after closing the form that contains the query, the SQL disappears.

Anyone come across this before?

Yup. For example

SELECT *
FROM
(subquery) Q

will be stored as

SELECT *
FROM
[subquery] AS Q

Sometimes this leads to confusion (of Access.


mfG
--> stefan <--

 

[scubadiver]

I created a query definition in VBA.

hi,

I have a query that contains a subquery and when I try to open the query
after closing the form that contains the query, the SQL disappears.

Anyone come across this before?

Yup. For example

SELECT *
FROM
(subquery) Q

will be stored as

SELECT *
FROM
[subquery] AS Q

Sometimes this leads to confusion (of Access.


mfG
--> stefan <--