[AccessD] Count of Unique Records

Mark Boyd MarkBoyd at McBeeAssociates.com
Wed May 28 09:57:46 CDT 2003


Charles -
Neither 'Distinct' nor 'DistinctRow' worked.
I am still getting a count of 4.

Mark

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Wednesday, May 28, 2003 10:43 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Count of Unique Records

Mark,

The Select statement can be qualified with either Distinct or
DistinctRow.  I am unable to tell you which is the more appropriate for
your situation from the information you provided.


Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at McBeeAssociates.com] 
Sent: Wednesday 2003 May 28 09:35
To: AccessD at databaseadvisors.com
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



More information about the AccessD mailing list