How to sub-summary sort with repetitions field?

[ML2008]

I need to set-up a report to be sorted by the values in fields with 3 repetitions. So far it works fine but it only sub-summary sorts the values on the first repetition. Any idea how to fix it!

[i have a list of office numbers and each receives one or more newspapers. I need to have it report what office numbers receice newspaper 1, 2, etc. The Newspapers are on a drop list that is assigned to the newspapers field (3 repetitions) I need it to list the office numbers by Newspaper.]

[Vaughan]

The only way to fix it is to split the repetitions into related records, then generate the report from the related database.

[bruceR]

This is exactly why you should not be using repeating fields. Create a true relational design. You cannot individually sort, select, or delete repeating fields. Filemaker went relational with version 3 and repeats were obsolete then except for special purposes and this isn't one of them.