News

Home / Calculating Distinct Counts In Access Experts

Calculating Distinct Counts In Access Experts

Calculating Distinct Counts in Access Experts Exchange. Experts-exchange.com SQL Servers Transact SQL and some other SQL dialects support the CountDistinct ColumnName syntax SELECT Category CountDistinct Num AS DistinctItems FROM SomeTable GROUP BY Category returns Category Num-----x 3 y 1 2. Select all Open in new window.

Products Center