Word 2003 receives no records from Access 2003 query

[Tor Michal Kinn]

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?

 

[Peter Jamieson]

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.aspx?scid=kb;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