Selecting Fields for a Report

[BruceF]

I'm creating a "mail merge" type of report that will allow secretaries to
print labels. One example will print a student's name, their homeroom
teacher, and room number. Another example will print the parent's name,
address, city, state, and zip. I want the secretaries to pick the fields they
need for the labels. I have a form created with 4 lines with 3 combo boxes in
each (12 total). It's sort of like a "label template". Each value in the
combo box is from a table called PossibleFields that has the name of each
field available such as Last Name, First Name, Birthdate, GuardianName,
Homeroom Teacher, Room Number, etc. They can choose any field from any combo
box. The label will look like the fields chosen from the combo boxes.

Is this possible? Is there a better way?

 

[KARL DEWEY]

I suggest preplaning and create a template for them so they only pick which
template to use and then select names.

Have you tried from the other side - Word Mail-Merge? Open a blank Word
document, click on menu TOOLS - Letters and Mailings - Mail Merge. It opens
an additional window on the right and has step-by-step instructions and
choices. You can also backup in the process. Works fine for me.

 

[Duane Hookom]

The Query By Form at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane gives
users the ability to select fields and set criteria etc. The results are a
couple clicks from sending/exporting to a Word Merge file. This would allow
users to create any Word label template they want and then use the records in
Word.