Showing only unique values

[chrisbrooke]

Hi, is there a way of showing only unique values, i.e. say the data was 111,2,2,3,444 for a particular field say name, of which is dave. What I want is a query with results that show for name=dave the results should be 1,2,3,4 and not the whole lot - just the different numbers.

 

[GumbyD]

Set the Unique Values property of the query to "yes"

GumbyD

 

[Pat Hartman]

How many times are you going to post the same question?

http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=225589#post225589