You will probably have difficulty in Word 2002 or later if your query has
any of the following:
a. runtime parameters (but then it probably would not be listed)
b. user-defined functions (i.e. functions written in Access VBA)
c. some of the financial series functions, and one or two other functions
such as "replace"
d. wildcards, e.g. used in a LIKE clause
e. references to data outside the Access database (this is a bit
hit-and-miss)
In most cases, you should be able to get around this by using the old DDE
method to connect - check Word Tools|Options|General|COnfirm conversions at
open, go through the connection process again, and select the DDE option
when it is offered.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Paul" wrote in message
...
I'm attempting to create a Mail Merge document using a Select query in MS
Access 2003, and I get error messages saying things like "Word was unable
to open the data source" or "Record 1 contained too few data fields." The
thing that puzzles me about this, however, is that I have no problem
connecting to a table in the same Access database. The problem only
occurs when I try to connect to a query.
Because of the data I need to merge into my document, however, I need to
use a query. Is there something I need to do when I'm trying to merge
with data in an Access query so that I can avoid these problems?
Thanks in advance,
Paul