Access 2003 - count unique values <p>How to count unique values in Access 2003? When i write sth like this: </p> <pre><code>SELECT DISTINCT Customer FROM CustomersTable; </code></pre> <p>I've got as result unique customers, but how count them if this code doesn't work:</p> <pre><code>SELECT COUNT(*) </code></pre> <p><code>FROM (SELECT DISTINCT Customer FROM CustomersTable )</code></p> <p>(it causes error: "The Microsoft Jet database engine cannot find the input table or query 'SELECT DISTINCT Customer FROM CustomersTable'. Make sure it exists and that its name is spelled correctly")</p> <p><em>Example of database</em></p> <pre><code>--Customer -- Address -- X NY X OR Y AR Z WA </code></pre> <p>And I'd like to have as result 3 (three unique Customers.) </p>