Does your query use any wildcards (*%_?) in a LIKE clause?
If so, you are probably encountering the problem described in
http://support.microsoft.com/default...b;en-us;234525
and you may need to change the dialect of SQL that is being used in your
database - if so, just bear in mind that the impact of a change could be
large.
Peter Jamieson
"Tor Michal Kinn" wrote in message
...
I got a query in Access 2003 (tried 2000 also).
When I run it in Access, it returns several records.
Then I try to merge it into Word or Excel 2003.
Then it return no records.
Any idea what the problem may be?