Can Query be imported into MS Word

[Shinken]

Is there any way to bring data from queries into MS Word?

I need to create lengthy, verbose reports, that include charts and selected data from an Access database. Microsoft Word is much better at this type of report, as they are essentially Word documents with graphs and selected data inserted into the report.

FYI, I'm using Office XP and the included versions of Access & Word.

I can import tables into Word from Access, but cannot import Queries. The information needed for the report, however, must be query-based, because the data is in multiple related tables in Access.

Thanks,

Shin

 

[giacomo1]

After you have queried your information You can export data from queries using the "Tools"..."Office Links" Menu Option. . GOOD LUCK!!

Giacomo

 

[Shinken]

Giacomo,

Thanks. "Publish as a Word Document" is just what I was looking for.

Shin

 

[HaChIrish]

Would I use a similar technique from 1 record in a form to a doc in MSWord?

 

[giacomo1]

Sure...Just write a query....something like this...


SELECT DISTINCT Name
FROM TBL_NAMES
WHERE [FORMS]![ADD]!CUST_NAME = [TBL_Name].[Name];

then just selct the publish to word...