Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / October 2004

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dot - 08 Oct 2004 17:55 GMT
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 - 08 Oct 2004 18:59 GMT
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

>-----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
>.
Doug Robbins - 09 Oct 2004 01:20 GMT
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.

Signature

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

>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
Jeannette Rivera - 09 Oct 2004 16:53 GMT
>-----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
>.

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.