In a merge document, can I use two sources in one word document?

[dot]

I have two tables in Access I wish to draw into one document. Is this
possible and I am not seeing how? It appears to not be possible.
Thanks

 

[Kirt]

Not that I'm aware of. But it sounds like you know your
Access, and that's a great start and can solve your mail
merge problems. Everytime you create a Database in mail
merge it saves it as an Access file (table) and it also
saves a Query too. In other words, whenever your in mail
merge its data is being screened by the Query, so if you
edit that Query, and add more tables to it and
create "Joins" between them, then BINGO, you've kept your
tables sepate, but bringing them together under one
Query, and you're maintenance will pratically be a breeze!

If you don't know much about "Joins" or "Relationships"
then you could create a third table that contains both
data and then edit your query to only contain that 3rd
table's data, but then any changes you make in tables 1
and 2 will have to be updated (copied and pasted, or
appended) to table 3.

Or lastly, you could export all of your tables into one
Excel work book and use that instead. I hope this helps.
www.dreamforce.us

 

[Doug Robbins]

Use a Select query in Access that links the two tables and use that query as
the data source.

Be aware though that Word cannot really handle a "multliple items per
condition" situation. Access alone can do it far better using
reports/subreports.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Jeannette Rivera]

-----Original Message-----
I have two tables in Access I wish to draw into one document. Is this
possible and I am not seeing how? It appears to not be possible.
Thanks
.