<div>
Excellent, thankyou. One of these days I need to start using the Design View because it's really easy...
</div>


<div>
<div class="content wysiwyg-content">
I have an Access table with a column called LogonUser. There are about 8 distinct values in this column, and each value is repeated multiple times. I would like some sort of SQL query that will return the 8 distinct values and how many times those values are repeated. So, for example<br />
<br />
Value1 &nbsp;8<br />
Value2 &nbsp;15<br />
Value3 &nbsp;70<br />
...etc...
</div>
</div>


I have an Access table with a column called LogonUser. There are about 8 distinct values in this column, and each value is repeated multiple times. I would like some sort of SQL query that will return the 8 distinct values and how many times those values are repeated. So, for example

Value1  8
Value2  15
Value3  70
...etc...

Access Select Distinct Count

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.