What's the best choice between report and external document?

michi.for

Registered User.
Local time
Yesterday, 16:22
Joined
Jan 13, 2016
Messages
45
Hi all,
i have a question about exporting or not a table data.

The result is a six page document where only in 2 pages i need to put data from a table.

What's the best solution?

Formatting a "six-pages report" or export data to a word or pdf document pre-formatted?

Thanks for your answers !
 
As it depends on me, I would choose for the second solution!
 
Normally, creating an Access report is quicker and my choice except where there is complicated formatting involved or where the user wants to do further editing, in which case I use Word.
 
Thanks for the answers:
what kind of access tools i need to "export" data from tables/queries to a word document?
 
Turn the problem around. Do it not from Access but from Word. There is such a thing as connecting Word to an Access table by building a template document - if your information is either tabular or you are willing to play with field-name substitutions. Look up the topic "Mail Merge," which was originally used to do form-letter generation.

Having said that, I would add that there is nothing wrong with building "boilerplate" reports either, if the first two pages and last two pages are essentially constant.

The final decision will always be yours, but here is the comparison of factors.

Using Access and a report with a two-page header plus a two-page footer, you have very limited formatting options for the long header and footer, but getting the tabular data in place would be very easy. At best, the header and footer could be improved by using the .RTF option rather than the text option for the implied text boxes.

Using Word and MailMerge features, your document will be a bit more awkward to program but the full power of Word's formatting options will be available to make your document have a particular alignment, justification (left, right, center, flush). You will have borders, watermarks, more tightly controller paragraph breaks and page breaks, and a generally more "document-oriented" file.
 

Users who are viewing this thread

Back
Top Bottom