Conditional Mail Merge per Student and Quarter

[marysilvaramos]

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