Microsoft Access Count Distinct Values Function

Ms Access Count Distinct function in normal SQL language is the function to determine the number of records of different non-NULL values, while Count function return the number of records regardless there are duplicates or not. However, in Access, the Count Distinct function is not actually existed. If you tried to use the function in

source http://database.access-templates.com/microsoft-access-count-distinct-values-function.html