mailmerge -- display some duplicate data

[Guest]

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)

 

[[MVP] S.Clark]

If you're data were normalized, such that the "checkbox data", and I use
that term loosely, were stored as a child to the parent, then a query could
be written to produce the desired output SUCH THAT it could result in a mail
merge to Word.

I know I didn't exactly make my English professor proud with that sentence,
but hopefully it gets the point across.

Suppose you had a Parent table, and each "Checkbox" were a Category.

tblParent
-----------
ParentID
date
state
title
description
URL
author

tblParentCats
--------------
ParentID
CatID

tblCats
--------
CatID
CatName

Now a query can join these three tables, where for each associated Cat, the
parent information for it could be listed.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting