Conditional Mail Merge per Student and Quarter
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
|