If you use the query designer, add your fields and set your filter, you can access the code by selecting View SQL from the menu, copy the code and paste the code where you need it.
Mike Gagnon
If you want to get the best response to a question, please check out FAQ184-2483 first.
By default the query designer places the data into a query.
INTO query.
I do not see an INTO statement on your SQL. Is it possible you stated to select another output type but did not provide all the information (like file or table name)?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.