Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I use crosstab queries as data source for merge letter
|
#2
|
|||
|
|||
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 ... |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot Find Its Data Source | Mailmerge | |||
Data Source | Mailmerge | |||
merging Word 2000 data source and word 2003 envelopes | Mailmerge | |||
disconnect a data source | Mailmerge | |||
Merge Data Source path | Mailmerge |