Count unique Container Number

[punter]

Hi,

I have a report that I'm trying to add something too. I want to count each time a unique container number is on the report. I have the count function =Count([Container_Number]) in the report footer. That counts every container on the report whether it is duplicated or not. Right now it is returning 832 containers but there are only 745 unique container numbers on the report. How would I get it to count the unique numbers on the report?

Thanks

Eddie.

 

[shudini]

Check out http://allenbrowne.com/ser-66.html, he has a ECount function that would allow you to do exactly that.

 

[punter]

Thank you so much for you reply. I did get it to work but this is a much better solution than I had.

Eddie.