Total Count on duplicate records

[philman2006]

I have a report that contains a machine number, tonnage number, and part number.  I need a count of all part part numbers assigned to particular machine number.  When I use Count it gives a total count for all items including duplicates.   If I use Running-Count I get the count of each line item including duplicates.  I would like to have my report display a total part numbers for each machine number.  For example I may have 20 line items for Machine 5.  I am getting a Count of 20.  Actually the report should be Machine 5 at 8 part numbers.

I would appreciate any assistance.  Thank you in advance for taking the time to respond.

If I have you confused I can elaborate more on the subject.

[spyder2000]

Try grouping the part number within machine number, then associating the count with the part numbers (on the group tab).

[philman2006]

I was able to figure it out with a little help.  I already had the grouping in place.  The hard part was that the "Distinct" option would not always appear.  It took me a few tries but I was finally able to get it.  Here is the formula.....

count(distinct(mold#))for machine#

Thanks for taking the time to respond.
Phil