Hello everyone, wondering if someone can please help me on this one, I am trying to create a script that will do two things on 20 different fields... First off my DB has a Field for "instructor" which is a list of 5 people and date feild that is a pop up calender. these two lists are used over and over again on each record on the 20 fields I have:
Skill Instructor Date
Skill1 Instructor Date
Skill2 Instructor Date
Skill3 Instructor Date
Skill4 Instructor Date
What I am trying to do is run a report that will have the instructor name: then the student's name, and a list of the skills and dates that he/she has done within each record. then print the next instructors name, then the student's name, and a list of the skills and dates that he/she has done, repeat, repeat... I also don't want to print empty fields.
What I have been able to do is create global fields to find the date range that I am looking for, but I can't get the report to run, everytime it shows all the fields even though they are not the correct dates because it is matching the date on a previous skill.
Thanks for any help on this.