mailmerge report -- some data repeated

T

tgwarrior

This might not be the correct forum to ask this question, please redirect me
if not.

I have a parameter query that selects data by date. The dataset is simply
the following set of fields:
-- date
-- state
-- title
-- description
-- URL
-- author
-- checkbox1
-- checkbox2
-- checkbox3
-- checkbox4
-- checkbox5

I want to be able to mailmerge data from this Access Query to a word
document so that the data can be displayed in the following way:

If [checkbox1] is checked, then...
-- state
-- title
-- description
-- URL
-- author
..... is displayed beneath its name.


If [checkbox2] is checked, then
-- state
-- title
-- description
-- URL
-- author
..... is displayed beneath its name.

etc.

Many entries will have checks in more than one checkbox. I'd like the
state/title/description/etc to be output under each checkbox header, if that
checkbox is checked.

Is there a way to do this? It needs to end up in a MS Word document (that's
mailmerged, or something similar) for a non-technical user to be able to get
this data.

Thanks for any ideas.

michael munson
(e-mail address removed)
 

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