View Single Post
  #2 (permalink)  
Old December 11th, 2005, 03:47 PM
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
Default

I think you should be able to do it with the following...

Add the name field to your query twice. Then hit the Group By button at the top of the Query Window (Its the thing that looks kind of like an 'E'.

On the second Name, click the drop down on Group By, and choose Count.

Yell if you need more info on this one,

Mike

Mike
EchoVue.com
Reply With Quote