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?

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?