A counting problem [RESOLVED]

[Pasvorto]

Let me see if I can 'splain this properly....

I am using CR9, by the way.

I have many records. Each record, in addition to other data, contains a date field and a shift field.

I have a group on the date. No problem. I have the report count how many days of production we had by doing a distinct count on the date field and placing it on the report footer. That works.

Now it gets dicey. I need a count of the shifts worked. For instance, on day one, I might have 12 records, but they are spread over 3 shifts. So that day would count as 3 shifts (not 12). The report footer needs to have the total count of shifts for all days ( the 3, not the 12). I can't use a distinct count or I will get "3". I can't use a count or I get "35" (when it should have been "18"). I have tried creating a variuos summary fields in the date group, but I can't summeraize those for the report totals.

Any ideas?