[AccessD] Count of Unique Records

Mark,

Use the find duplicates wizard and then look at the SQL it creates.

Michael R. Mattys
www.mattysconsulting.com

----- Original Message ----- 
From: "Mark Boyd" <MarkBoyd at McBeeAssociates.com>
To: <accessd at databaseadvisors.com>
Sent: Wednesday, May 28, 2003 10:57 AM
Subject: RE: [AccessD] Count of Unique Records


> 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
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>