record count in report

[ekennedy]

I have a report that has two levels of grouping, A and B. I want to get a
count of unique A and B combinations. Currently if I do a count of A or B it
give me a total number of records, whether they are unique or not.

Is there a way of telling the Count function to only count unique items?
Thanks

 

[Ofer Cohen]

You can count records using

=Sum(IIf(Criteria = True , 1 , 0))

That way it will sum up all the 1'ns when the criteria (unique items) met.

 

[ekennedy]

how do you determine if a pair of items are unique within a report? I have a
stepped report where step one is ordered by A and step two is orders by B.