I need a calculation to arrive at the number of vendors used from a list of sold items.Each item has a vendor number.The find shows vendor 101 may appear 23 times, vendor 203 may appear 15 times. I need to summarize the number of vendors used. The answer I am looking for is:Number of Vendors= 2

Create a self-relationship based upon vendor number. Create a calculated field:

Mark (calculation, number) =

Case(Min(Rel::RecordID) = Record ID, 1, 0)'

RecordID is just a unique ID for each record. This will mark the first record for each vendor. If you subsummarize on this field you will get the number of vendors.

-bd