Thread: Count Distinct
View Single Post
  #3 (permalink)  
Old August 14th, 2006, 01:03 PM
Jonas Jonas is offline
Authorized User
 
Join Date: Jul 2006
Location: , , .
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi Mike,

Thanks for the reply, but that just gives me the total number of claims. what i need is the number of different claims names (IE claim-1, claim-2etc) even if theirs 100 different claims with the name "mike" it should only count it once.

Suggestions?

Reply With Quote