Reporting In Word With Access Datasource 
Author Message
 Reporting In Word With Access Datasource

Has anyone tried to create a report formatted in Word that replicates the
"detail" portion of an Access report?  I would like to use the formatting
available in Word, but am unsure how to replicate the way Access produces
variable numbers of lines in its detail section.  This whole project should
run as a mail merge document.

Bob

--
 R & D Data Consulting Inc.
"Databases That Work The Way YOU Do!"



Sun, 10 Jul 2005 22:59:18 GMT  
 Reporting In Word With Access Datasource
Hi Rddataconsulting,

Quote:
> Has anyone tried to create a report formatted in Word that replicates the
> "detail" portion of an Access report?  I would like to use the formatting
> available in Word, but am unsure how to replicate the way Access produces
> variable numbers of lines in its detail section.  This whole project should
> run as a mail merge document.

This last bit is the problem. You have two possible methods available, that
are briefly described in the Special Merges section of my website; there are
links to sample files. I think the DATABASE field approach is most
appropriate (and it's easiest to set up). The link on my website is
incorrect, it was changed to

http://www.knowhow.com/Guides/DatabaseInfo/DatabaseInfo.htm

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://www.mvps.org/word
http://go.compuserve.com/MSOfficeForum

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)



Mon, 11 Jul 2005 02:44:19 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing ADO datasources in Word

2. Duplex Word doc with Access Report from Access

3. move between Access and Word, back to Access, Close word

4. Mail Merge - Word was unable to open the datasource

5. Word.DataSource Object

6. Feeding Word from an external datasource

7. Automate Word - MailMerge - Datasource

8. MS Word 97 Mail Merge with Oracle Datasource?

9. Word Labels from ODBC DataSource

10. MS Word 97 Mail Merge with Oracle Datasource?

11. Report in Access to Word....

12. Linking an existing Word docs into Access reports

 

 
Powered by phpBB® Forum Software