Use an Access Report in a WORD Document

[jboyle]

I have an Access database that creates a report of qualified vendors. I also have a business report that is created in WORD that has a vast amount of information including a table of qualified vendors. I keep forgetting to modify the WORD document to reflect the most recent qualified vendors. I would like the WORD document to Link to the Access database to ensure the most recent qualified vendors are in the document.
Thanks in advance - John

 

[The_Doc_Man]

Read up on Mail Merge operations with Word. You want this merge to be in "catalog" mode. That is the mode that creates only one file with a list of elements inside it, not necessarily separated by any particular character such as the form feed (page break to the Word purists...)

Word and Access work together quite nicely in this regard.

Build a query in Access that holds exactly what you want to see in the order you want to see it. Then base your merge operation on that query rather than the raw data table. That way you get better control over what gets printed.