How to count distinct records in MS Access

2 records returned. Count distinct records that contain NULL values The query below is the inner query we just saw which shows a list of distinct values in the ReportsTo column. Note that when we run this query alone, NULL is displayed in the result set,

www.geeksengine.com