Thread: Count Distinct
View Single Post
  #2 (permalink)  
Old August 11th, 2006, 10:57 AM
echovue echovue is offline
Friend of Wrox
Join Date: Oct 2004
Location: Clinton, UT, USA.
Posts: 564
Thanks: 0
Thanked 4 Times in 4 Posts

Hi Jonas,

Use the access query builder, and specify that table. Then drop the Claim ID field down twice, click the grouping button on the top, and then ensure that the group by for the first is Group By, and the Second one is Count.

Hope that helps,


Reply With Quote