Performing a COUNT which excludes duplicates

[xtreme1]

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I'm attempting to query a table, and count all records in a certain field *excluding* duplicates.&nbsp;&nbsp;I'm sure this solution is extremely simple, but I can't seem to get my mind around to what I need to do.&nbsp;&nbsp;If anyone can just point me in the right direction it would be appreciated!&nbsp;&nbsp;<br><br>Ex: <br>&nbsp;&nbsp;&nbsp;&nbsp;A field with customers named &quot;Smith&quot;, &quot;Johnson&quot;, &quot;Smith&quot;, and &quot;Craven&quot; would only return a total count of three, counting only once for &quot;Smith&quot;.&nbsp;&nbsp;Thanks for any help in advance! <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>

 

[gol4]

right click on the QBE grid under query properties set unique values to yes this will eliminate dupes