<div>
Wonderful, thank you very much for taking the time to answer my query.
</div>


Wonderful, thank you very much for taking the time to answer my query.

<div>
<div class="content wysiwyg-content">
How can I achieve the following please? I want the data shown in the first column to be summarised to only show one of the possible values in the Colour Column. Have a look below and it should make more sense.<br />
<br />
Thanks in advance.<br />
<br />
Name &nbsp; &nbsp; Colour<br />
Jones &nbsp; &nbsp; &nbsp;Red<br />
Jones &nbsp; &nbsp; &nbsp;Red<br />
Smith &nbsp; &nbsp; Red<br />
Smith &nbsp; &nbsp; Blue<br />
Smith &nbsp; &nbsp;Yellow<br />
Clark &nbsp; &nbsp; Blue<br />
<br />
To return this<br />
<br />
Name &nbsp; &nbsp; Colour<br />
Jones &nbsp; &nbsp; Red<br />
Smith &nbsp; &nbsp; Red<br />
Smith &nbsp; &nbsp; Blue<br />
Smith &nbsp; &nbsp;Yellow<br />
Clark &nbsp; &nbsp; Blue
</div>
</div>


How can I achieve the following please? I want the data shown in the first column to be summarised to only show one of the possible values in the Colour Column. Have a look below and it should make more sense.

Thanks in advance.

Name     Colour
Jones      Red
Jones      Red
Smith     Red
Smith     Blue
Smith    Yellow
Clark     Blue

To return this

Name     Colour
Jones     Red
Smith     Red
Smith     Blue
Smith    Yellow
Clark     Blue

Access summarise unique values in tables

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.