Create a calculation field in the parent table (assume you have the relationships built properly between the parent and child) to count the number of enrolments in the child table; then you can do search on this calculation field.
No, I don't feel that is what I am looking for, but thank you for you reply Kglsong.
Export programs field with "Group by" option, then you get summary of each person. You can get result in the file as adding count of summary field to it.
I managed to resolve the issue using a multitude of steps.
The first step was to create a calculation field which tired itself to the FY. A simple Case ( FY = 2015 ; 1 ; "" ), just assigned a 1, created in the child table.
Step 2 was to create a calculation field to count those 1's in my child table.
Step 3 was to use that calculation in my parent table and use that as the basis for my summarized break field, and sort by that value in my child table.
This sub summarized my programs by FY wonderfully. However, I changed the FY hard coded value to use a global variable, capturing what the user types in for which FY report the user wants to run.
Since my program table is a child table it contains many programs by a one person (one to many). I then added scripting code to omit duplicate names, which reduced my counts to their perfect numbers, such as when 1 person takes 4 programs. A simple count of ID's gives the the grouped people count contained in the grouped programs.
This all worked together beautifully! Thank you everyone for your replies. I do appreciate your time and suggestions.