[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.

 

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