Re: SELECT COUNT(Distinct surname)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 31 Jan 2006 18:50:55 -0700

On Tue, 31 Jan 2006 23:58:40 -0000, "laura" <replyto@xxxxxxxxx> wrote:

>"SELECT COUNT (DISTINCT surname) FROM tblClients" might do the trick, but I 
>keep getting a syntax error message saying that there is a missing operator. 

Unfortunately the JET query engine does not support the ANSI standard
SELECT COUNT(DISTINCT...) operator.

You'll need to use a subquery:

SELECT Count(*) FROM
(SELECT DISTINCT Surname FROM tblClients);

                  John W. Vinson[MVP]    
.

Follow-Ups:
- Re: SELECT COUNT(Distinct surname)
  - From: laura

References:
- SELECT COUNT(Distinct surname)
  - From: laura

Prev by Date: Re: IIF question getting #ERROR Message
Next by Date: Re: Combining Query Outputs
Previous by thread: Re: SELECT COUNT(Distinct surname)
Next by thread: Re: SELECT COUNT(Distinct surname)
Index(es):
- Date
- Thread