How do I count unique items in field in Access query?

by

Try this

SELECT Count(*) AS N
FROM
(SELECT DISTINCT Name FROM table1) AS T;

Read this for more info.

More Related Contents:

  1. sql in ms-access [closed]
  2. Managing and debugging SQL queries in MS Access
  3. How do I write a full outer join query in access
  4. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  5. How to simulate UNPIVOT in Access?
  6. Table-less UNION query in MS Access (Jet/ACE)
  7. SQL Query – Using Order By in UNION
  8. Ms Access Query: Concatenating Rows through a query
  9. Date Difference between consecutive rows
  10. Pivoting data in MS Access
  11. coalesce alternative in Access SQL
  12. Top n records per group sql in access
  13. Access-SQL: Inner Join with multiple tables
  14. Address standardization within a database
  15. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  16. How to SUM two fields within an SQL query
  17. How to use system username directly in MS Access query?
  18. Achieving ROW_NUMBER / PARTITION BY in MS Access
  19. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  20. SQL Updating from an inner join
  21. Lightweight SQL database which doesn’t require installation [closed]
  22. Convert String to Date in MS Access Query
  23. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  24. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  25. How do I perform update query with subquery in Access?
  26. SQL Update woes in MS Access – Operation must use an updateable query
  27. SQL SET DEFAULT not working in MS Access
  28. How do I create a decimal field in Access with Alter Table?
  29. Access substitute for EXCEPT clause
  30. Escaping ‘ in Access SQL

Leave a Comment