[AccessD] Count of Unique Records

Sure. 

SELECT Count(field)
FROM datasource
GROUP BY field
  ----- Original Message ----- 
  From: Mark Boyd 
  To: AccessD at databaseadvisors.com 
  Sent: Wednesday, May 28, 2003 10:35 AM
  Subject: [AccessD] Count of Unique Records


  I have a table with the following records:

  John

  John

  Bill

  Bob



  I need to find out how many unique records there are.

  My current approach is 1 query grouping the above table.

  Then, I get a count of grouped records with a 2nd query.



  Is there a way to avoid using 2 queries for this?

  The above is obviously an example.  The table actually holds thousands and thousands of records.



  Thanks,

  Mark Boyd

  Sr. Systems Analyst

  McBee Associates, Inc.





------------------------------------------------------------------------------


  _______________________________________________
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030528/8d8629f0/attachment-0001.html>