Conditional Mail Merge per Student and Quarter

marysilvaramos · #1 01-11-2013, 08:30 AM

Hi:

Our school needs to create the report cards using the attached format (ImageReport.jpg). We opted to create a mail merge since ms access would not created a report easily.The data is extracted from our Ms Access db. Attached is an image of the data (ImageDatabase.jpg).

The issue we are having is to filter the information: each student have several subjects, the grades and percentages should be listed per quarter (field named Col1_Grade_Period = 1,2,3,4), ie: all the information subjects (grade, percentage, conduct, effort) from the quarter 1 in the column Quarter 1, same for the rest of quarters.

Is that possible? and how?

Thanks in advance

Mary

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mail Merge Duplication of address on merge	RICKY	Mail Merge	1	09-26-2012 03:14 PM
Mail merge conditional adress blocks.	Thrizian	Mail Merge	2	07-17-2012 10:41 PM
Conditional merge fields in mail merge	Aude	Mail Merge	1	01-06-2012 07:38 PM
Saving INDV mail merges During the mail merge	sedain121	Mail Merge	2	10-04-2011 07:52 PM
Word not highlighting conditional Merge fields	Dunce	Mail Merge	0	02-15-2010 05:44 AM