How do I get my Access report into Word with a table format?

[Guest]

I need to submit a report in Word, that originates in Access. Additionally,
it needs to have the data appearing as a table in Word. Is there any way to
make data appear in an Access report in table format, and in a way that can
be exported to Word still appearing as a table? Thanks for any help.

 

[Larry Linson]

You can use COM automation to create a Table in your Word document,
containing the information generated in your report. You can, most likely,
open a Recordset on the same, or similar, query that you use as the
RecordSource of your Report and move through the Recordset, controlling Word
via automation as you go.

If that won't work, say because of calculated Controls in the Report, and/or
Sorting and Grouping, you can create the table in the Word document before
executing the report, and include code to populate the values by embedding
it in the Format or Print events of appropriate Report Sections.

Larry Linson
Microsoft Access MVP