You probably need to write a query in Access that pulls all the data
together in the format you need. If each table has the same data structure,
a UNION query such as the following might be enough:
SELECT * FROM TABLE_A
UNION
SELECT * FROM TABLE_B
UNION
SELECT * FROM TABLE_C
However, if you are using WOrd 2002/2003 you will probably find that the
default connection method (OLEDB) does not "see" UNION queries and you will
either have to wrap the query up in yet another query, or use a different
connection method (check Tools|Options|General|"Confirm conversion at open"
then go through the data source setup).
If you are not in a position to modify the Access database or have it
modified, you could consider
a. creating a new Access database and putting the query in there. It can be
done, but Word may have difficulty using that as a data source. Or
b. using VBA and the OpenDataSource method to issue the query directly.
Ask again if you need further info. on those approaches.
--
Peter Jamieson - Word MVP
Word MVP web site
http://word.mvps.org/
help said:
I have an address database, but in that database there are 3 tables that
have address information. Each table has a different set of addresses, such
as 1 table is project addresses, another table is architect addresses. In
word I need to use mail merge but be able to pull the information from all
three of these tables. Is there a way that I could do that? I'm trying to
make a template so that the users can just hit the ABC button and the
information from all three tables is already in there. Is this possible?
