strange behaviour

[Carlo]

Hi to everybody, I found a strange behaviour in ACCESS
2000.
I made a query and I tested it. It works like I want and
it returns the data I wanted.

I opened the SQL code for that query and copied it in
another query and, surprisingly, it does not work anymore.
It does tell me that there is a sintax error.

Is it possible that a simple copy and past causes this
failure?

Thanks to anyone!!!!
-Carlo-

 

[Graham R Seach]

Carlo,

Does the query contain a subquery? If so, Access has the annoying habit of
adding a dot after the subquery definition, which you have to remove
manually.

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia