Summarizing data into a report (with subreports) and would like to get it into Word

[davefwelch]

I've been working for about a month now to add queries and reports to a database that will summarize a whole lot of data about public water systems into reports that we can further edit and then send to the water systems.

What I currently have is an Access 2003 database linked to a bunch of (I believe to be) Oracle tables. I've written quite a few (over 20) queries that filter, massage, and compile all the data we have in our database about all the water systems (water test results, water sources, etc) into a report that generates a 3 to 4 page report for each water system.

So, what I would REALLY like to do is have a nicely-formatted Word document that I could parse into the 384 separate documents, one for each water system. I think I'm almost there (see attached), but I have a few questions.

1) Note how irregular the horizontal lines are aligned on the right end. Of course, this is happening because those are actually just a bunch of "_" because Access can't export directly to doc.

2) Note how the Source Water Assessment boilerplate paragraph left alignment is messed up. Again, I think this is happening because I'm first having to export to an rtf. I tried inserting the boilerplate info as Word objects as well as Wordpad objects, but those wouldn't even print!

So I mean, all in all I seem to be in good shape, but I just wanted to make sure that I'm on the right track here. Is there a simpler way to go about this, or am I stuck with this half-#$@ed method? Is Access 2007 any more adept at exporting formatting, such as horizontal lines? Any help would be greatly apprteciated.

 

[GaryPanic]

beyond me - but at a glance - have you looked at the "super easy word "
this might do it - effectively you format the word doc to your requirements and it shoudl do what you want (I think)

I have this in my d/b and it does what I need, number formats can go tits up so you might need to read up on switches in word

 

[davefwelch]

Thanks Gary!

I did just look into that option, but it does seem like a lot of work for what may be little or no reward, because "super easy word" seems to be primarily designed for creating mail merges, and as far as I know, subreports do not lend themselves well to being inserted into mail merges. Does anyone else have some ideas about inserting a subreport into a mail merge?