Hi.
I have a report that contains duplicated fields. Also in the group header is a hidden field:
Name:AAA
Control Source: =1
I was told by a list member (Rich) that if I sum the 1s from the group header in the report footer it would give me an accurate count of all distinct records (and not duplicated ones).
He told me to use the following as the control source for the count in the footer:
=AAA RunningSum
and set the Running Sum property to Over Group. This didn't work, it returned a zero instead.
Am I doing something wrong? When I typed the above, it auto-corrected to:
=[AAA].RunningSum
Please help! I'm already past my deadline and the bosses are getting frisky!
Gram
I have a report that contains duplicated fields. Also in the group header is a hidden field:
Name:AAA
Control Source: =1
I was told by a list member (Rich) that if I sum the 1s from the group header in the report footer it would give me an accurate count of all distinct records (and not duplicated ones).
He told me to use the following as the control source for the count in the footer:
=AAA RunningSum
and set the Running Sum property to Over Group. This didn't work, it returned a zero instead.
Am I doing something wrong? When I typed the above, it auto-corrected to:
=[AAA].RunningSum
Please help! I'm already past my deadline and the bosses are getting frisky!
Gram