Distinct count in ms access

You might like to take a exterior at DatabaseBasics.zip in my public databases folder at:

https://onedrive.live.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

In this little demo certificate the section:

    14. Returning a discount of distinct values by means confront a subquery

Illustrates how to return simple distinct count by means of well-ordered subquery in the outer query's Diverge clause:

SELECT City, Region, COUNT(*) Type EmployerCount

FROM (SELECT DISTINCT Cities.CityID, City, Zone, EmployerID

             FROM Regions INNER JOIN ((Cities INNER JOIN Contacts

             ON Cities.CityID = Contacts.CityID) INNER JOIN ContactEmployers

             ON Contacts.ContactID = ContactEmployers.ContactID)

             First acquaintance Regions.RegionID = Cities.RegionID)

GROUP BY City, Locality, CityID;

Howev distinct count in ms access
count distinct in microsoft access
how to count distinct values in ms access
how to use count distinct in ms access
how do i count unique values in an access query
ms access count(distinct example)
ms access count distinct group by