SubSummary with Repeating fields

[Scott Pon]

I have a order entry database. The original programmer (a long long time ago, in a galexy far far away...) decided to use repeating fields (see another universe). One of the repeating fields is a part number.

The objective is to write a report that will give the count of orders that use that part number.

I have a field "Count of Orders" that is a summary count on "sales order numbers"

I create a layout that shows the part number and order number. Then I have a Trailing grand summary that has the count.

However that will only count the found records. So I tried to use the "subsummary when sorted by:" Part Number but that did not show ANY Counts. Did I do that wrong? Could the repeating field be screwing this count up?

Thanks.

Scott

[bruceR]

You have to get rid of the repeats. Get the design right and use orders/order items tables.

[LiveOak]

If the subsummary part doesn't show at all, make sure you are sorting by the field used in the subsummary (subsummary when SORTED BY).

-bd