Creating Certificates For Multiple Fields
I am working on a summer camp database where our students can earn up to 3 academic awards. I have 3 fields (AcademicAward1, AcademicAward2, AcademicAward3) for those awards. I am trying to setup a certificate to print the awards. The certificate should only list one award at a time (if they have multiple awards) and I am trying to get them to print in alphabetical order of the participants. Is there an easy way to do this?