Visual Basic: SQL - count distinct records. Question 20263951
I have tried query select count(F1) from (select distinct F1 from Table) on Access 2000 and it works well. It does not work on Access 97...
Mixing DISTINCT and COUNT in an SQL
Because DISTINCT and Count() do not seem to " work and play well with each other" in MS-Access. :) I can determine the distinct entires and display them...
Contents
Concurrent Access to Tables with Exclusive Locks · Databases with Transactions ... COUNT DISTINCT and COUNT UNIQUE Functions · COUNT column Function...
sql with COUNT and by DISTINCT
Doesn't work with Access Jet database (would work with SQL Server). You'll need one query to select distinct, then select count in a second query...
SitePoint Forums - Count Distinct
Access will not allow a count(distinct) in it. Don't ask me why. I guess because it would be usefel. You are correct provided you use a select distinct,...
SQL COUNT DISTINCT Function
Note: The following example works with ORACLE and Microsoft SQL server but not with Microsoft Access. The keyword DISTINCT and COUNT can be used together to...
Access Count Distinct
Access Count Distinct
