record count in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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.
 
Back
Top