buhrian

I am working on a solution for my school. In it, most fields have up to 20 repetitions. I have all the repetitions on the layout. However, I don't want the repetition (or the label for the field) to print if there is nothing in that specific repetition. Additionally, not all records have information entered in the same number of repetitions. For example, record 1 may have data entered in 5 repetitions while record 2 may have data entered in only 1 repetition. I know this is the matter of a simple calculation, but I'm going nuts trying to figure it out. Thanks so much for your help!!!

I meant calculation instead of script. Brian

I started to try to make a script, but don't know if I'm on the right track. Here's what I've got so far. GetRepetition ( MeetingDate ; 2 ) IsEmpty ( MeetingDate ) ??

I've got a database where all the fields have 20 repetitions. This is to set up meetings. Any given person can have up to 20 meetings. However, I may be in meeting #3, Joe may be in meeting #5, and Sandy may be in meeting #1. Regardless of what repetition any record is on, I need it to sort and print by date. How do I set up my layout so that it allows for all repetitions, but only prints a repetition if it has a date in the date field?