Query With no Repeats!

[Bob]

My Query has Clients, Horses, and percentages, how can I stop repeats. So
same Client, horse, and percentage only show once.

Thanks in advance.........Bob Vance

 

[Bob]

I have them in a dropdown combo box , but I don't want any repeats...Thanx
Bob

 

[John Vinson]

My Query has Clients, Horses, and percentages, how can I stop repeats. So
same Client, horse, and percentage only show once.

Thanks in advance.........Bob Vance

View the query's Properties; set the "Unique Values" property to Yes.

John W. Vinson[MVP]

 

[Steve Schapel]

Bob,

In design view of the query, right-click anywhere on the background of
the upper panel of the query design window, and then select Properties
from the pop-up menu. Change the Unique Values property to Yes.