Output multiple queries to 1 word document

H

Heidi

I want to know if it's possible to output/export data from several different
queries into the one word document for use in writing a report.
 
V

Vincent Johns

Heidi said:
I want to know if it's possible to output/export data from several different
queries into the one word document for use in writing a report.

The answer to your question is "yes".

Oh, you wanted details? OK, the way I'd do it is to create a new query
which invokes all the other ones and presents all the information I need
to use in the report. Then, in Word, I'd set up a "MailMerge" link to
that new query in the database so that I could put the desired fields
into the report. You can set it up to put more than one record from the
query onto each page if you wish.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 

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