Pick and Choose Data for Mailing Lists

[Lee T.]

Several departments in the city where I work have dbs for
mailing lists and call for papers. The people are grouped
by specialty but they can be in more than one specialty.

They would like to have the ability to select more than
one specialty and create the mailing labels or MAIL MERGE
for the call to papers letters. How can I create a form
that will all them to pick and chose all the specialties
they want but do a select distinct on the group.

Right now I have a query for each specialty. I don't know
if I need to try and combine them in code or write a new
query that will pass in all the specialties as they are
selected from the form. There are about 70 specialties
and they add 4 or 5 more per year (and delete about the
same as well).

Thanks,

Lee T.

 

[PC Datasheet]

Sounds like you need to add a new field called Selected (Yes/No) to the
Speciality table. And then you need a continuous form including the Selected
field and the name of each specialty where the user would check off the
speciality he/she wanted. And finally, your mailing labels report and mail merge
would be based on a query that contained the Selected field with the criteria of
True.


--
PC Datasheet
A Resource for Access, Excel and Word Applications
(e-mail address removed)
www.pcdatasheet.com

· Design and basic development for new applications
· Additions, Modifications and "Fixes" for existing applications
· Mentoring for do-it-yourselfers who want guidance
· Complete application design and development
· Applications Using Palm Pilot To Collect Data And
Synchronize The Data Back To Access Or Excel