integrating data into a word document for report purposes

  • Thread starter Brook Morris via AccessMonster.com
  • Start date
B

Brook Morris via AccessMonster.com

Good morning folks,

I am using Access 2000 and need some assistance. I need to know if there is
a way to create a report where the information is extracted from a query and
placed into a MS word document or template. Let me explain the process:
1. A mishap occurs and the investigator responds to the scene and does his
investigation.
2. Investigator returns and puts the info obtained into a database.
3. The database currently has an input screen with multiple tabs for
different info areas of the investigation.
4. The "mishap narrative" is a memo box that contains the sequence of events
in chronological order.
5. Then we fill in the causation in another tabbed memo field called
"Causation".
6. Again another called "Recommendations".

7. In order for the investigator to compile the formal report we have an MS
word template where we cut and paste the info in steps 4-6 into the template.


Step 7 above is what I want to avoid!

Is there a way to force a new document any time one of those three fields are
filled with data?

I'm at a big loss here folks.

Thanks for your time in this matter

Sincerely
Brook
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top