Do not print all repetitions

[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!!!

[T-Square]

Buhrian--

Welcome to the Forums.

Ditch the repeating fields and build related tables to store the data about your different entities. Examples of tables for a school situation might include: Students, Courses, Registrations.

There is a lot in these forums about how to go about building such a system, and there are a lot of resources (online, at your local public library, bookstores, etc.) that exist to teach you how to build a solid relational design.

Once the structure is utilizing the powers of relational design, you can build layouts/reports that show exactly what you want.

David