Merging three reports into one and storing them in Word.

[Goddoctor]

I have three separate reports that are basically too large to be made into one in Access. I am currently taking them to a rich text file in Word and manually merging them as one. This works but is time consuming. Is there any way that I can do this automatically using a macro or code to where they will be merged and stored in Word and also to where they can be mergerd and printed automatically. Thanks.

Doc.

 

[dhoffman]

I'm not the expert on this kind of thing so I may easily be very wrong, but offhand I don't believe Access supports the merging of reports. You're absolutely sure you can't fit everything into one report?

 

[Goddoctor]

Absolutely sure. Every time I try make just one report, it gives me a too many fields defined error.

Doc

 

[Carol]

Could you not use subreports within a main report in Access and then bring together using the Master/Child linking.

By the way - how many fields are you using.