If you are using Word 2003 (and probably Word 2002) and the query is not
listed, there are two possible work-arounds:
a. check Word Tools|Options|General|COnfirm conversions at open, then go
through the connection process again and choose either DDE or ODBC when
prompted. If you choose DDE, select the Query tab when offered and you
should see the crosstab query. If you choose the ODBC route, you will need
to click the Options button and check all the options to see the queries.
b. using the default connection method (OLEDB) you can work around this as
long as you can create a further query in Access that uses the crosstab
query as its "base table" and returns all its data, e.g. if you have a
crosstab query called ctq1, create a further query called ctq2 with the
following SQL

SELECT ctq1.* FROM ctq1

You should be able to select that query as the data source for the merge.
(I've only done this with a simple example so there may be other problems,
but it seems to work)

Peter Jamieson


"ss" wrote in message
...