Suppressing Repeating Values in Query

[Dibs]

Hi,

Is there any way to suppress repeating rows in a query?

Any help in this regard is highly appreciated.

Thanks in advance.

Dibs

 

[Guest]

Click in properties, unique values.

 

[Glenn]

In design view switch to SQL view (View menu) then insert
DISTINCT after the SELECT statement e.g.
SELECT DISTINCT Something.....

Glenn