I have an access database that consists of multiple tables, queries, reports,
and forms. I am attempting to create a merge document that uses data from
several of the tables in the database.

From what I've seen so far, I can only connect my merge document to one of
the tables (or one data source). Is there any way possible to connect the
Word merge document to multiple tables and or multiple databases?

No, you will have to create a select query that combines all of the required
data into a single source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Khrissi" wrote in message
...
I have an access database that consists of multiple tables, queries,
reports,
and forms. I am attempting to create a merge document that uses data from
several of the tables in the database.

From what I've seen so far, I can only connect my merge document to one of
the tables (or one data source). Is there any way possible to connect the
Word merge document to multiple tables and or multiple databases?

Thank you, Doug, this was very helpful. I should have realized this, but for
some reason my brain just wasn't functioning properly...lol.

Thanks again.

"Doug Robbins" wrote:

No, you will have to create a select query that combines all of the required
data into a single source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP
"Khrissi" wrote in message
...
I have an access database that consists of multiple tables, queries,
reports,
and forms. I am attempting to create a merge document that uses data from
several of the tables in the database.

From what I've seen so far, I can only connect my merge document to one of
the tables (or one data source). Is there any way possible to connect the
Word merge document to multiple tables and or multiple databases?