SeekingOne
Programmer
I need to create mailing labels based on a group. I have five tables joined together. Student, Semester, Address, Grades, and Grades Detail. I need to printout a mailing for each Student that has between 45 and 70 hours earned. Thus, I need to sum the earned hours in the Grades Detail record. If the total is 45 to 70 hours, I need to print a label.
Is it possible to do this in one report?
I presently have a report with the name and address information in a group header, the earned hours for each sememster in the detail section (but supressed) and the total hours earned in the group footer. I then have a group select that requires the total to be between 45 to 70 hours. If I send this output to a file, I could then create labels from the file. However, is there a way to do this in ONE report?
Thanks in advance,
Debbie Folks-Huber
University of Illinois
Is it possible to do this in one report?
I presently have a report with the name and address information in a group header, the earned hours for each sememster in the detail section (but supressed) and the total hours earned in the group footer. I then have a group select that requires the total to be between 45 to 70 hours. If I send this output to a file, I could then create labels from the file. However, is there a way to do this in ONE report?
Thanks in advance,
Debbie Folks-Huber
University of Illinois