Enhance SQL aggregate functions with DISTINCT (count distinct, sum distinct, avg distinct)
The DISTINCT option for aggregate functions is actually missing.
It is really strange that we do not have the count distinct functionality (without a costly workaround) in MS Access, all databases engines provide that, even Excel can do it now through PowerPivot modeling.
this is a missing function since long time ago, and your documentation for dcount as a solution is not correct, and I have posted that in the feedback for the article.
Please do this simple modification and make us feel that you are not really killing this great program...